Skip site navigation (1) Skip section navigation (2)

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

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>
Subject: Re: problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7
Date: 2001-12-11 15:48:57
Message-ID: 17222.1008085737@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
"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

In response to

Responses

pgsql-admin by date

Next:From: Heather JohnsonDate: 2001-12-11 17:22:19
Subject: Re: problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7
Previous:From: Richard NAGYDate: 2001-12-11 15:26:46
Subject: Strange thing : ldconfig and libpq.so.2.1

pgsql-general by date

Next:From: Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=Date: 2001-12-11 15:53:04
Subject: Re: RedHat6.2 - postgres 7.1.2 lib confusion
Previous:From: Tom LaneDate: 2001-12-11 15:46:12
Subject: Re: bug or my ignorance ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group