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...