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

From: "Webb Sprague" <webb(dot)sprague(at)gmail(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "General PostgreSQL List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: FK creation -- "ON DELETE NO ACTION" seems to be a no-op
Date: 2007-12-21 20:36:35
Message-ID: b11ea23c0712211236s160e18c8lb3b870a8f90aefae@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> >
> > ... "currentsessions_username_fkey" FOREIGN KEY (username)
> > REFERENCES authorizedusers(username) ON UPDATE CASCADE
>
> Hmm, NO ACTION is the default.

Oh, how embarrassing. Never mind...

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2007-12-21 20:59:21 Re: Restoring 8.0 db to 8.1
Previous Message brian 2007-12-21 20:35:56 Re: self ordering list