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.