| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | "Roderick A(dot) Anderson" <raanders(at)acm(dot)org> |
| Cc: | 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:11:05 |
| Message-ID: | 20030812080954.A11777-100000@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 12 Aug 2003, 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.
Well, the constraint still got an autogenerated name, so you probably
could have used that, although you might end up affecting more constraints
than you had meant.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2003-08-12 15:13:59 | Re: How to prevent vacuum and reindex from deadlocking. |
| Previous Message | Teodor Sigaev | 2003-08-12 15:03:59 | Re: Tsearch limitations |