Re: Update of foreign key values - Mailing list pgsql-general

From Roderick A. Anderson
Subject Re: Update of foreign key values
Date
Msg-id Pine.LNX.4.33.0308111635280.12601-100000@main.cyber-office.net
Whole thread Raw
In response to Re: Update of foreign key values  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: Update of foreign key values  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
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..."


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.4Beta1 "failed to create socket: Address family not
Next
From: p_design@gmx.net
Date:
Subject: pgadmin