Postgres Pro
Downloads
Home   >   mailing lists

Re: trigger to enforce FK with nulls? - Mailing list pgsql-sql

From Alvaro Herrera
Subject Re: trigger to enforce FK with nulls?
Date
Msg-id 20060413012221.GB14482@surnet.cl
Whole thread Raw
In response to trigger to enforce FK with nulls?  (George Young <gry@ll.mit.edu>)
List pgsql-sql
Tree view 
George Young wrote:

> Since foreign keys per se can't do this, I presume the way
> is to use triggers, though I have not used triggers before.

Says who?  Just don't specify NOT NULL on the referencing column.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-sql by date:

Previous
From: George Young
Date:
Subject: trigger to enforce FK with nulls?
Next
From: Stephan Szabo
Date:
Subject: Re: trigger to enforce FK with nulls?