Re: Transactions and unique constraint

Sorry about that, please forget it. This works, it was my fault.
Verena

Am Montag, 12. Juni 2006 15:04 schrieb Verena Ruff:
> Hi everyone,
> I have a problem with 2 inherited tables and a primery key constraint.
>
> table a ( id serial primary key );
> table b () inherits (a);
> alter table b add constraint
>
> If I delete one record of a, and then insert the same values into b, there
> is an error telling me there is a duplicate key violating the unquie key
> constraint.
>
> This 2 queries are following directly each other in my PHP code. If I run
> the 2nd query (which inserts the values) afterwards with psql, it works. It
> seems like Postgres needs some time recognizing that the primary key isn't
> used any more. These queries are part of a transaction.
>
> Any hints how I get this working?
>
> Thanks,
> Verena
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend