Add ON UPDATE CASCADE to an existing table

#1

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

#2

On Oct 22, 2004, at 2:50 AM, Matt Arnilo S. Baluyos wrote:

Quote:

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/curre...ltertable.html

Sean

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

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Add ON UPDATE CASCADE to an existing table

comp.databases.postgresql.novice comp.databases.postgresql.novice

Add ON UPDATE CASCADE to an existing table - 10-22-2004 , 02:50 AM

Re: Add ON UPDATE CASCADE to an existing table - 10-22-2004 , 06:12 AM