Re: altering foreign keys

[Richard Broersma Jr <rabroersma@xxxxxxxxx>]

--- On Tue, 1/22/08, Adam Rich <adam.r@xxxxxxxxxxxxx> wrote:

> Is there a way to alter the 
> existing keys? (it didn't jump out at me in the manual)

    ALTER TABLE your_table
DROP CONSTRAINT your_column_fkey_constraint,
 ADD CONSTRAINT your_column_fkey_constraint 
    FOREIGN KEY your_column
     REFERENCES parent_table( primary_column )
      ON UPDATE CASCADE;

Regards,
Richard Broersma Jr.

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

               http://archives.postgresql.org/