Hi,
I recently added a check constraint onto a table in my database, that uses a stored procedure to check one of the inserted columns against the data of another table.
I know that this is stretching the limit of what a check constraint is meant to be, but is there a way, short of editing the pg_restore list manually every time, to guarantee that the table used for validation is populated before the table with the data being validated?
Right now it is restoring out of order, and the table is not getting populated correctly.
if I have to rewrite as a trigger, I will do that, but I like the check constraint because it checks all of the entries when it's applied. Any suggestions?
--
Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering
"Quality is not an act, it is a habit." -- Aristotle
