Postgres Pro
Downloads
Home   >   mailing lists

Re: Multi-column constraint behaviour - Mailing list pgsql-general

From Bertram Scharpf
Subject Re: Multi-column constraint behaviour
Date
Msg-id 20070117092111.GC16093@bart.bertram-scharpf.homelinux.com
Whole thread Raw
In response to Re: Multi-column constraint behaviour  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Hi,

Am Dienstag, 16. Jan 2007, 15:51:58 -0500 schrieb Tom Lane:
> Bertram Scharpf <lists@bertram-scharpf.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

pgsql-general by date:

Previous
From: Ashish Karalkar
Date:
Subject: Cursor body?
Next
From: Jorge Godoy
Date:
Subject: Re: [1/2 OFF] Varlena.com inaccessible from .br (Blocked?)