Strange error related to temporary tables

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Strange error related to temporary tables
Date: 2006-08-31 14:58:51
Message-ID: 1157036331.3033.57.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Postgres version: 8.1.3

I have a code similar to this pseudo-code:

try {
create temp table temp_report ...;
... do some processing using this table...
drop table temp_report;
commit;
} catch all errors {
rollback;
}

This code occasionally triggered the following error (couldn't reliably
reproduce):

SQL state: 42710

ERROR: type "temp_report" already exists

The code is possible to be executed in parallel by multiple threads, on
different connections, or in sequence on the same connection. I would
expect it in both cases to work correctly... in manual tests I was able
to create in parallel temporary tables named identically in different
connections, and on the same connection after rolling back the
transaction which created the first table... so I don't know what to try
to trigger this.

Any ideas what's the problem ?

TIA,
Csaba.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2006-08-31 15:02:49 Re: Cutting the Gborg throat
Previous Message Dave Page 2006-08-31 14:50:48 Re: Cutting the Gborg throat