--- On Tue, 1/22/08, Adam Rich <adam(dot)r(at)sbcglobal(dot)net> 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.