Alter table to "on update cascade"

From: Aram Fingal <fingal(at)multifactorial(dot)com>
To: Postgres-General General <pgsql-general(at)postgresql(dot)org>
Subject: Alter table to "on update cascade"
Date: 2010-11-17 16:32:32
Message-ID: AD8F43FA-BEB3-4042-835F-51FF6BEA0806@multifactorial.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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. From the documentation on www.postgresql.org, about ALTER TABLE it's not at all clear how to do this or even whether you can do this.

-Aram

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Voras 2010-11-17 16:32:56 Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Previous Message Ivan Voras 2010-11-17 16:22:51 Re: Survey on backing up unlogged tables: help us with PostgreSQL development!