rule on insert

From: "Razvan Radu" <razvanr(at)digiview(dot)ro>
To: <pgsql-general(at)postgresql(dot)org>
Subject: rule on insert
Date: 2000-10-27 15:00:37
Message-ID: 001101c04026$aaf2aee0$0101a8c0@digiview.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello,

I have a problem with a rule "on insert"

I have a table "my_table" with a field named "index"
that has a default value of "nextval('seq')"

and the folowing rule
------------------------------------------------------
CREATE RULE log_ins AS ON INSERT TO my_table
DO INSERT INTO log(tbl,idrow,query,time)
VALUES('my_table',NEW.index,'INSERT','now'::text) ;
-----------------------------------------------------

my problem is:

in "log" table I have for "NEW.index" a value of 13
amd in "my_table" I have for "NEW.index" a value of 14
always (+1) which is the increment of sequence "seq"

can someone help me ?

P.S. what is the suntax for multiple actions in a rule ?

-razvan-

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-10-27 15:01:00 Re: What is the listserver at hub.org doing?
Previous Message Tom Lane 2000-10-27 14:54:27 Re: Re: [GENERAL] 7.0 vs. 7.1 (was: latest version?)