Skip site navigation (1) Skip section navigation (2)

Re: [SQL] Rule (which multiple actions) problem with history table.....

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: maillist(at)remo(dot)demon(dot)co(dot)uk
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Rule (which multiple actions) problem with history table.....
Date: 2000-02-27 23:41:39
Message-ID: 19669.951694899@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
maillist(at)remo(dot)demon(dot)co(dot)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

In response to

Responses

pgsql-sql by date

Next:From: Peter EisentrautDate: 2000-02-27 23:54:59
Subject: Re: [SQL] Nested BEGIN...COMMIT transactions
Previous:From: maillistDate: 2000-02-27 22:45:31
Subject: Rule (which multiple actions) problem with history table.....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group