I didn't see anything in the documentation about deferred constraints. Can you point to someplace where I can read about them?
Thank you! RobR -----Original Message----- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2008 2:59 PM To: Rob Richardson Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How do I save data and then raise an exception? On Fri, Oct 3, 2008 at 8:56 AM, Rob Richardson <[EMAIL PROTECTED]> wrote: > No, because the application first saves the coils and then saves the > charge. Setting up the foreign key constraint would prevent any coils > from being saved because the charge record would never exist at the > time the coil record was created. You should be able to set your constraints to deferrable initially deferred and get proper behaviour even with that update system. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
