salah jubeh <[email protected]> writes:
> I have some rules on the table and I have dropped them and everything went
> fine.
Rules are macros, and have the usual issues with multiple evaluations of
multiply-referenced arguments.
> CREATE OR REPLACE RULE status_change_ins AS
> ON INSERT TO account DO INSERT INTO account_status_change_log
> (account_id,
> account_status_id, status_change_date)
> VALUES (new.account_id, new.account_status_id, now());
You'd be far better off doing that with a trigger.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
