| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Palle Girgensohn <girgen(at)partitur(dot)se> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: The Data Base System is in recovery mode |
| Date: | 2000-10-17 16:07:02 |
| Message-ID: | 1295.971798822@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Palle Girgensohn <girgen(at)partitur(dot)se> writes:
> I have a problem with postgresl-7.0.2 on Freebsd 4-stable.
> query: declare curse cursor for select personid,foretag,fnamn,enamn,titel,telefon,mobil,email,tidpunkt, lower(foretag) from wtabmaria order by lower(foretag)
> query: fetch forward 20 from curse
> Server process (pid 15342) exited with status 139 at Tue Oct 17 14:37:20 2000
Hm. I couldn't duplicate this crash using
7.0.2-plus-some-7.0.3-patches. However I don't recall any bug fixes for
cursors in the 7.0.* branch. Could you provide a more complete bug
report, like the complete schema for the table? Also, can you provide
a gdb traceback from the corefile that the crashing backend hopefully
left behind in the database subdirectory ($PGDATA/data/base/yourdb)?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-10-17 16:37:56 | Re: SELECTs return error with oid in WHERE clause |
| Previous Message | Ilya Goldberg | 2000-10-17 16:00:27 | OID in WHERE clause of SELECT results in error |