z

application/octet-stream

Filename: z
Type: application/octet-stream
Part: 0
Message: RAISE concatination/variables in plpgsql
invoking IpcMemoryCreate(size=1245184)
FindExec: searching PATH ...
ValidateBinary: can't stat "/usr/local/bin/postmaster"
ValidateBinary: can't stat "/usr/bin/postmaster"
ValidateBinary: can't stat "/bin/postmaster"
ValidateBinary: can't stat "/cygdrive/z/PUBLIC/postmaster"
ValidateBinary: can't stat "/cygdrive/c/WINDOWS/postmaster"
ValidateBinary: can't stat "/cygdrive/c/windows/COMMAND/postmaster"
ValidateBinary: can't stat "/usr/bin/postmaster"
ValidateBinary: can't stat "/cygdrive/c/GCC/BIN/postmaster"
ValidateBinary: can't stat "/cygdrive/c/SERVERS/POSTGR~1/BIN/postmaster"
ValidateBinary: can't stat "/cygdrive/c/NOVELL/CLIENT32/postmaster"
ValidateBinary: can't stat "/cygdrive/c/PROGRA~1/BORLAND/CBUILD~1/BIN/postmaster"
ValidateBinary: can't stat "/cygdrive/c/PROGRA~1/BORLAND/CBUILD~1/PROJECTS/BPL/postmaster"
ValidateBinary: can't stat "/cygdrive/c/PROGRA~1/MTS/postmaster"
ValidateBinary: can't stat "/C/postmaster"
ValidateBinary: can't stat "/PROGRA~1/AVG6/postmaster"
ValidateBinary: can't stat "/cygdrive/c/PROGRA~1/TCL/BIN/postmaster"
ValidateBinary: can't stat "/cygdrive/c/PROGRA~1/PFE/postmaster"
FindExec: found "/usr/local/pgsql/bin/postmaster" using PATH
DEBUG:  database system was shut down at 2001-04-19 17:18:39 
DEBUG:  CheckPoint record at (0, 402809000)
DEBUG:  Redo record at (0, 402809000); Undo record at (0, 0); Shutdown TRUE
DEBUG:  NextTransactionId: 176466; NextOid: 1113566
DEBUG:  database system is in production state
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
postmaster: reaping dead processes...
postmaster: ServerLoop:		handling reading 8
postmaster: ServerLoop:		handling reading 8
postmaster: ServerLoop:		handling writing 8
postmaster child[3490087]: starting with (postgres -d2 -e -v131072 -p tst )
postmaster: BackendStartup: pid 3490087 user shenshall db tst socket 8
FindExec: searching PATH ...
ValidateBinary: can't stat "/usr/local/bin/postgres"
ValidateBinary: can't stat "/usr/bin/postgres"
ValidateBinary: can't stat "/bin/postgres"
ValidateBinary: can't stat "/cygdrive/z/PUBLIC/postgres"
ValidateBinary: can't stat "/cygdrive/c/WINDOWS/postgres"
ValidateBinary: can't stat "/cygdrive/c/windows/COMMAND/postgres"
ValidateBinary: can't stat "/usr/bin/postgres"
ValidateBinary: can't stat "/cygdrive/c/GCC/BIN/postgres"
ValidateBinary: can't stat "/cygdrive/c/SERVERS/POSTGR~1/BIN/postgres"
ValidateBinary: can't stat "/cygdrive/c/NOVELL/CLIENT32/postgres"
ValidateBinary: can't stat "/cygdrive/c/PROGRA~1/BORLAND/CBUILD~1/BIN/postgres"
ValidateBinary: can't stat "/cygdrive/c/PROGRA~1/BORLAND/CBUILD~1/PROJECTS/BPL/postgres"
ValidateBinary: can't stat "/cygdrive/c/PROGRA~1/MTS/postgres"
ValidateBinary: can't stat "/C/postgres"
ValidateBinary: can't stat "/PROGRA~1/AVG6/postgres"
ValidateBinary: can't stat "/cygdrive/c/PROGRA~1/TCL/BIN/postgres"
ValidateBinary: can't stat "/cygdrive/c/PROGRA~1/PFE/postgres"
FindExec: found "/usr/local/pgsql/bin/postgres" using PATH
DEBUG:  connection: host=127.0.0.1 user=shenshall database=tst
DEBUG:  InitPostgres
DEBUG:  StartTransactionCommand
DEBUG:  query: DROP FUNCTION tstktxt(text);
DEBUG:  ProcessUtility: DROP FUNCTION tstktxt(text);
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: CREATE FUNCTION tstktxt(text) RETURNS text AS '
DECLARE
	key ALIAS FOR $1;
BEGIN
	RAISE NOTICE ''Id number '' || key || '' not found!'';
	RETURN key;
END;
' LANGUAGE 'plpgsql';
DEBUG:  ProcessUtility: CREATE FUNCTION tstktxt(text) RETURNS text AS '
DECLARE
	key ALIAS FOR $1;
BEGIN
	RAISE NOTICE ''Id number '' || key || '' not found!'';
	RETURN key;
END;
' LANGUAGE 'plpgsql';
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: DROP FUNCTION tstkint(int4);
DEBUG:  ProcessUtility: DROP FUNCTION tstkint(int4);
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: CREATE FUNCTION tstkint(int4) RETURNS int4 AS '
DECLARE
	key ALIAS FOR $1;
BEGIN
	RAISE NOTICE ''Id number '' || key || '' not found!'';
	RETURN key;
END;
' LANGUAGE 'plpgsql';
DEBUG:  ProcessUtility: CREATE FUNCTION tstkint(int4) RETURNS int4 AS '
DECLARE
	key ALIAS FOR $1;
BEGIN
	RAISE NOTICE ''Id number '' || key || '' not found!'';
	RETURN key;
END;
' LANGUAGE 'plpgsql';
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: SELECT tstktxt('Test');
DEBUG:  ProcessQuery
NOTICE:  plpgsql: ERROR during compile of tstktxt near line 4
ERROR:  parse error at or near "|"
DEBUG:  AbortCurrentTransaction
DEBUG:  StartTransactionCommand
DEBUG:  query: SELECT tstkint(42);
DEBUG:  ProcessQuery
NOTICE:  plpgsql: ERROR during compile of tstkint near line 4
ERROR:  parse error at or near "|"
DEBUG:  AbortCurrentTransaction
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 3490087 exited with status 0
Smart Shutdown request at Thu Apr 19 17:20:00 2001
DEBUG:  shutting down
DEBUG:  database system is shut down
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
postmaster: reaping dead processes...