Maybe try pltclu - you may use socket (TCP/IP) or to write data to OS filesystem. I was doing in pltclu very similar things. Write what you concrete watnts (in points), then I will try to write you scripts. Regards Blazej 2008/10/3 Rob Richardson <Rob.Richardson@xxxxxxxxxxx>: > 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:tgl@xxxxxxxxxxxxx] > Sent: Friday, October 03, 2008 8:47 AM > To: Rob Richardson > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: [GENERAL] How do I save data and then raise an exception? > > "Rob Richardson" <Rob.Richardson@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
