Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Rule (which multiple actions) problem with history table..... - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] Rule (which multiple actions) problem with history table.....
Date
Msg-id 19669.951694899@sss.pgh.pa.us
Whole thread Raw
In response to Rule (which multiple actions) problem with history table.....  (maillist@remo.demon.co.uk)
List pgsql-sql
Tree view 
maillist@remo.demon.co.uk writes:
> The problem is with the rule on update.
> This fails with the error... 
> ERROR:  INSERT has more expressions than target columns

FWIW, this seems to work fine in current sources (7.0beta1).  It's
difficult to muster much enthusiasm for figuring out why it was
broken in 6.5...
        regards, tom lane

pgsql-sql by date:

Previous
From: maillist@remo.demon.co.uk
Date:
Subject: Rule (which multiple actions) problem with history table.....
Next
From: Peter Eisentraut
Date:
Subject: Re: [SQL] Nested BEGIN...COMMIT transactions