Horton

Re: problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Heather Johnson" <hjohnson@nypost.com>
Cc: pgsql-admin@postgresql.org, "Harry Ford" <hford@globix.com>, "Serge Canizares" <serge@enluminaire.com>, "Marie Musacchio" <marie@nypost.com>
Date: 2001-12-11T15:48:57Z
Lists: pgsql-general 
"Heather Johnson" <hjohnson@nypost.com> writes:
> Sure, this is what I get:

> 2001-12-11 09:40:24 DEBUG:  StartTransactionCommand
> 2001-12-11 09:40:24 DEBUG:  query: select count(*) from users where id not =
> in (select users_id from users_demographics)
> /opt/postgres/bin/postmaster: reaping dead processes...
> /opt/postgres/bin/postmaster: CleanupProc: pid 26260 exited with status 0

Strange.  That looks like a perfectly normal exit from the backend.
Could you attach to the backend with a debugger and set a breakpoint
at proc_exit, so we can see how it's getting there?

			regards, tom lane