> Hm, that sounds like some sort of conflict with a temp table.  Is it
> possible that you have been using a temp table name that matches the
> sequence name?  Are there any pg_class entries whose names begin with
> pg_temp, and if so could we see details on those too?

Some more input from Konstantin (his answer to my message bounced
from bug-list -:)):

> > 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.

Vadim

Tue, 3 Apr 2001 09:20:29 -0700 
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
RE: [BUGS] Loosing files after backend crash 
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
> Some more input from Konstantin (his answer to my message bounced
> from bug-list -:)):

> 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??

			regards, tom lane

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