> >
> > ... "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
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
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