Re: Update of foreign key values

From: Dennis Gearon <gearond(at)cvc(dot)net>
To: "Roderick A(dot) Anderson" <raanders(at)acm(dot)org>
Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Update of foreign key values
Date: 2003-08-12 15:22:30
Message-ID: 3F390636.8020403@cvc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yuup, always name constraints so it's easier to remove them. And if you name them meaningfully, then others might understand why they exist! (or later after a coffeeless morning)

Roderick A. Anderson wrote:

> On Mon, 11 Aug 2003, Stephan Szabo wrote:
>
>
>>Yes. Either DEFERRABLE or INITIALLY DEFERRED must be given in order for
>>set constraints to be meaningful. This might be another good place to
>>consider a little clarification (or maybe a doc note in the interactive
>>docs)
>
>
> Phew. I thought I was going bonkers. Then add that I never named the
> constraints so I was still out'a luck.
>
>
> Rod

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-08-12 15:25:39 Re: Commercial support?
Previous Message Dennis Gearon 2003-08-12 15:19:49 Re: PL/C functions