Re: Update of foreign key values

On 11 Aug 2003, Ron Johnson wrote:

> Maybe this will do it:
> http://www.postgresql.org/docs/7.3/static/sql-set-constraints.html

Saw this but my take was it required the original constraint to be created
with the deferred(able) option. But hey, I'll give it a try since all my
other attempts have increased the number of barley pops I'll _have_ to
drink tonight! One more won't hurt (well maybe in the morning.)

> begin;
> set constraint foo DEFERRED;
> update parent_table;
> update child_table;
> commit;

Rod
--
"Open Source Software - Sometimes you get more than you paid for..."