Palle Girgensohn <[EMAIL PROTECTED]> 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

Reply via email to