--- On Tue, 1/22/08, Adam Rich <[EMAIL PROTECTED]> 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/
