Postgres Pro
Downloads
Home   >   mailing lists

Alter table to "on update cascade" - Mailing list pgsql-general

From Aram Fingal
Subject Alter table to "on update cascade"
Date
Msg-id AD8F43FA-BEB3-4042-835F-51FF6BEA0806@multifactorial.com
Whole thread Raw
Responses Re: Alter table to "on update cascade"  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: Alter table to "on update cascade"  (David Fetter <david@fetter.org>)
List pgsql-general
Tree view 
I have a table where I should have declared a foreign key with ON UPDATE CASCADE and didn't.  Now I want to fix that.
Fromthe documentation on www.postgresql.org, about ALTER TABLE it's not at all clear how to do this or even whether you
cando this.   

-Aram

pgsql-general by date:

Previous
From: Fredric Fredricson
Date:
Subject: Re: The first dedicated PostgreSQL forum
Next
From: Ivan Voras
Date:
Subject: Re: Survey on backing up unlogged tables: help us with PostgreSQL development!