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

I'm not sure how to go about doing that Tom. If it doesn't inconveniece you
too much, could you let me know how to go about it?

Heather

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Heather Johnson" <hjohnson(at)nypost(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>; "Harry Ford" <hford(at)globix(dot)com>; "Serge
Canizares" <serge(at)enluminaire(dot)com>; "Marie Musacchio" <marie(at)nypost(dot)com>
Sent: Tuesday, December 11, 2001 10:48 AM
Subject: Re: [ADMIN] problems doing sub-selects on PostgreSQL 7.1.3 and
Solaris 7

> "Heather Johnson" <hjohnson(at)nypost(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org