Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[NOVICE] Add ON UPDATE CASCADE to an existing table

1 view
Skip to first unread message

Matt Arnilo S. Baluyos

unread,
Oct 22, 2004, 2:53:44 AM10/22/04
to

hello everyone,

how do i add an ON UPDATE/DELETE CASCADE constraint to an existing table?


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Sean Davis

unread,
Oct 22, 2004, 6:26:33 AM10/22/04
to

On Oct 22, 2004, at 2:50 AM, Matt Arnilo S. Baluyos wrote:
>
> how do i add an ON UPDATE/DELETE CASCADE constraint to an existing
> table?

Do you mean a foreign key constraint? I think this may help.

http://www.postgresql.org/docs/current/static/sql-altertable.html

Sean


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

0 new messages