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

2007-12-21 Thread Webb Sprague
> > > > ... "currentsessions_username_fkey" FOREIGN KEY (username) > > REFERENCES authorizedusers(username) ON UPDATE CASCADE > > Hmm, NO ACTION is the default. Oh, how embarrassing. Never mind... > > -- > Alvaro Herrerahttp://www.CommandPrompt.com/ > The Postgr

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

2007-12-21 Thread Alvaro Herrera
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

[GENERAL] FK creation -- "ON DELETE NO ACTION" seems to be a no-op

2007-12-21 Thread Webb Sprague
Hi list, First, my select version() gives: PostgreSQL 8.2.4 on x86_64-pc-linux-gnu, compiled by GCC x86_64-pc-linux-gnu-gcc (GCC) 4.1.2 (Gentoo 4.1.2 p1.0.2) The Problem: when I run ALTER TABLE currentsessions ADD CONSTRAINT currentsessions_username_fkey FOREIGN KEY (username) REFERENCES autho