[SQL] Creating constraint sometime fail in a transaction

2004-06-05 Thread Olivier Hubaut
Hi, I've a strange bug on PgSQL 7.3.3 with function, constraints and transactions. As the foreign key are too heavy for a massive insert, even set defered, we've decided to put them in a function in order to enable/disable them. So, in such a transaction, first we disable the constraints, using

Re: [SQL] Creating constraint sometime fail in a transaction

2004-02-20 Thread Tom Lane
Olivier Hubaut <[EMAIL PROTECTED]> writes: > So, we're wondering if the action for putting/removing constraint could > be executed out of the transaction, so that it may overlaps and crash in > such case. > Does anyone notice the same problem? When you didn't show us exactly what you're doing o