z
application/octet-stream
Filename: z
Type: application/octet-stream
Part: 0
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...