| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alexander Presber <aljoscha(at)weisshuhn(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org, Bernhard Weißhuhn <bkw(at)weisshuhn(dot)de>, Frank Wittig <fw(at)weisshuhn(dot)de>, jw(at)weisshuhn(dot)de |
| Subject: | Re: Errors with temporary tables |
| Date: | 2005-11-24 15:30:28 |
| Message-ID: | 13797.1132846228@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alexander Presber <aljoscha(at)weisshuhn(dot)de> writes:
> We encounter the following two strange errormessages when working
> with temporary tables.
> 1) ERROR: duplicate key violates unique constraint
> "pg_type_typname_nsp_index"
> 2) ERROR: tuple concurrently updated
The first of these looks like the same problem we've seen reported
before of a table's rowtype not getting dropped when the table is
dropped. The second one is new though. Can you reproduce it?
If so, a debugger backtrace from the errfinish() call would be very
helpful.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Witney | 2005-11-24 15:42:48 | Re: "invalid page header in block 597621 of relation..."error |
| Previous Message | David Pratt | 2005-11-24 15:29:26 | Postgres as embedded db for GUI |