Re: Multi-column constraint behaviour

From: Bertram Scharpf <lists(at)bertram-scharpf(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Multi-column constraint behaviour
Date: 2007-01-17 09:21:11
Message-ID: 20070117092111.GC16093@bart.bertram-scharpf.homelinux.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Am Dienstag, 16. Jan 2007, 15:51:58 -0500 schrieb Tom Lane:
> Bertram Scharpf <lists(at)bertram-scharpf(dot)de> writes:
> > Is there a deeper reason why the foreign key allows not
> > referenced non-null values
>
> The SQL spec says so. Use MATCH FULL to get the behavior you want.

Ah, I should have seen that in the documentation. Sorry for
the noise.

Thanks to all,

Bertram

--
Bertram Scharpf
Stuttgart, Deutschland/Germany
http://www.bertram-scharpf.de

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jorge Godoy 2007-01-17 09:54:55 Re: [1/2 OFF] Varlena.com inaccessible from .br (Blocked?)
Previous Message Ashish Karalkar 2007-01-17 08:30:11 Cursor body?