RE: [GENERAL] FOREIGN KEY syntax

The following information is based on gram.y file of postgres sources

FOREIGN KEY ( columnList ) REFERENCES tableName [ ( columnList) ] [MATCH
FULL] [ON DELETE action] [ON UPDATE action]

[[NOT] DEFERRABLE] [INITIALLLY {IMMEDIATE | DEFERRED}] (not all matches are
allowed)

"action" is {NO ACTION | RESTRICT | CASCADE | SET NULL_P | SET DEFAULT }

[ .. ] means optional elements
{ .. | .. | ..} means exactly one of

Regards,
Andrzej Mazurkiewicz

andrzej(at)mazurkiewicz(dot)org

www.mazurkiewicz.org

> -----Original Message-----
> From: Ron Peterson [SMTP:rpeterson(at)yellowbank(dot)com]
> Sent: 2 marca 2000 20:19
> To: pgsql-general(at)postgreSQL(dot)org
> Subject: [GENERAL] FOREIGN KEY syntax
>
>
> I've downloaded and installed the 7.0 beta. Works great so far!
>
> I noticed on the change list that foreign key support has been added.
> However, information about the use of this feature hasn't made it into
> the documentation yet. Can anyone give me some examples of how to use
> FOREIGN KEY in postgresql?
>
> Ron Peterson
> rpeterson(at)yellowbank(dot)com
>
> ************