Postgres Pro
Downloads
Home   >   mailing lists

Re: FK creation -- "ON DELETE NO ACTION" seems to be a no-op - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: FK creation -- "ON DELETE NO ACTION" seems to be a no-op
Date
Msg-id 20071221203321.GD13293@alvh.no-ip.org
Whole thread Raw
In response to FK creation -- "ON DELETE NO ACTION" seems to be a no-op  ("Webb Sprague" <webb.sprague@gmail.com>)
Responses Re: FK creation -- "ON DELETE NO ACTION" seems to be a no-op
List pgsql-general
Tree view 
Webb Sprague escribió:

> It is not updating the table correctly to reflect the "no action".
> After \d currentsessions (and some editing) I get the following,
> which, as I understand it, should say something about the "ON DELETE
> NO ACTION":
>
>   ... "currentsessions_username_fkey" FOREIGN KEY (username)
> REFERENCES authorizedusers(username) ON UPDATE CASCADE

Hmm, NO ACTION is the default.

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

pgsql-general by date:

Previous
From: "Bryan Wilkerson"
Date:
Subject: self ordering list
Next
From: brian
Date:
Subject: Re: self ordering list