Hi I have code that does (inside a single transaction)
DROP TABLE IF EXISTS mytable; CREATE TABLE mytable .... Occasionally this produces ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index" DETAIL: Key (typname, typnamespace)=(mytable, 2200) already exists. I can get away from this by using CREATE TABLE IF NOT EXISTS in the same code, but there's the potential that the wrong data will end up in the table if that happens, and it also seems a little.... odd. Would you not expect this transaction to be atomic? ie at commit time, the transaction should drop any table with the same name that has been created by another transaction. Geoff -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
