Re: bug ? updates and insert crash the backend

Laurent Perez <downloader@free.fr> writes:
> We're running Postgresql 7.3.2 on Linux boxes, two Debian systems and a
> RH one, kernel 2.4.18 and 2.4.9. Recently, we've been experiencing the
> following troubles, on every production box : updates and inserts appear
> to crash the backend, then the backend restarts after 1-2 seconds.

Would you rebuild with --enable-debug (and --enable-cassert, for good
measure) and get a stack trace from the resulting core dump?

> If someone wants to help me, I can provide the whole dump of the 't2g_1'
> database I am currently using. The dump is ~500KB in size.

If you want to send it to me off-list, I'll take a look ...

            regards, tom lane