> > How much time passed after sequence creation till crash?
> >> 
> >> About 5-10 seconds. I opened a transaction, created a sequence,
> >> created a temporary table with one column having NEXTVAL(seq) as
> >   ^^^^^^^^^^^^^^^^^^^^^^^^^
> >> default, inserted some data into the table, committed the 
> >> transaction.
> >> After that I ran my function, which crashed the backend after 
> >> 3-4 seconds of work.
> 
> Hmm.  Maybe the WAL redo is messing things up??

It could mess up pg_class content, but it never deletes
files (currently).

Vadim

Tue, 3 Apr 2001 09:59:43 -0700 
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
RE: [BUGS] Loosing files after backend crash 
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
>> Hmm.  Maybe the WAL redo is messing things up??

> It could mess up pg_class content, but it never deletes
> files (currently).

I'm not convinced that any files have really been deleted.  Maybe it's
just that the pg_class entries are wrong, or even more likely that the
indexes on pg_class are messed up (pointing at the wrong pg_class rows).

			regards, tom lane

Tue, 03 Apr 2001 13:03:35 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [BUGS] Loosing files after backend crash 