On 01/12/2012 08:42 AM, Carlos Mennens wrote:
I seem to have an issue where I can't modify a table due to another
tables foreign key association:
...
How does one accomplish my goal? Is this difficult to change or once
that foreign key is created, are you stuck with that particular
constraint?
Try updating the values in both tables within a transaction with
constraints set to deferred:
http://www.postgresql.org/docs/current/static/sql-set-constraints.html
Cheers,
Steve
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
