> > 4) If you want to pull information from another table, you either need to set > up a FOREIGN KEY relationship that you can leverage or you need to do a > query in the trigger function that pulls in the necessary information. >
I do not get where the "OR" comes from. There is nothing magical about FOREIGN KEY that causes NEW magically contain additional values. Foreign Key or not you still have to "...do a query in the trigger function...". David J. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
