| From: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM> |
|---|---|
| To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, ???????????? ?????????? <ks(at)tcnet(dot)ru> |
| Cc: | "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | RE: [BUGS] Loosing files after backend crash |
| Date: | 2001-04-03 16:20:29 |
| Message-ID: | 8F4C99C66D04D4118F580090272A7A234D3368@sectorbase1.sectorbase.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fredrik Hultkrantz | 2001-04-03 16:23:52 | International characters and the jdbcdriver |
| Previous Message | bpalmer | 2001-04-03 16:15:29 | Re: Final call for platform testing |