That's how it should have been done, but it wasn't. It's too late to change it now. If I make any change to the C++ code, I run into a horrible case of DLL Hell. I told my bosses that if we change any C++ code at that site, we have to change all of it. So I need a pure database solution. Or maybe something else. Now I'm thinking of a Python script, of which there are several running on site.
RobR -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2008 8:47 AM To: Rob Richardson Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How do I save data and then raise an exception? "Rob Richardson" <[EMAIL PROTECTED]> writes: > I think I just came up with a thoroughly ugly idea. The database > supports an annealing shop, in which coils are assigned to charges. > After the check fails, I end up with coils assigned to a charge that > does not exist. I could set up a job that runs every minute and > checks all coils with status "Assigned" to make sure that the > associated charges actually exist. That would fix another recurring > problem, in which a user intentionally deletes a charge but the > charge's coils stay assigned to that charge. Why don't you have a foreign key constraint from coils to charges? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general