On Mon, Dec 8, 2008 at 2:31 PM, Richard Broersma <[EMAIL PROTECTED]> wrote: > One Idea that popped into my head that may-or-may-not work would be to > add a constraint trigger that checks if all of the detail records have > the same xmin as the order table record.
Yes, it's not as simple as I first thought when I read it. I'd look at using a udf that used a sec definer that only it had to do the row adds and do everything at once, inserting to both tables at the time of the creation of the order. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql