| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heather Johnson | 2001-12-11 17:22:19 | Re: problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7 |
| Previous Message | Richard NAGY | 2001-12-11 15:26:46 | Strange thing : ldconfig and libpq.so.2.1 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= | 2001-12-11 15:53:04 | Re: RedHat6.2 - postgres 7.1.2 lib confusion |
| Previous Message | Tom Lane | 2001-12-11 15:46:12 | Re: bug or my ignorance ? |