2012-02-21_15:51:30-0500 Ron Peterson <rpeterso@mtholyoke.edu>:
> My rule below does not insert the the same uuid value into the test_log
> table as is created in the test table when I insert a new value. I know
> I've worked through this before, but I'm not remembering why this is.
> What's a right way to do this?
Obviously I can use a trigger function. I'm mostly wondering if there
are any tricks to accomplishing this with rules (I like the simple
syntax). I suspect the problem here is that 'new' on insert refers to
the function used to calculate the new value, /not/ the new value that
is actually inserted into the table. There are probably reasons for
that; but it would seem nicer to refer to the actual new table value
rather than the expression used to calculate it. My 2c.
-Ron-
> create table test (
> anid
> uuid
> not null
> default encode( gen_random_bytes( 16 ), 'hex' )::uuid
> primary key,
> value
> text
> );
>
> create table test_log (
> anid
> uuid,
> value
> text,
> op
> text,
> attime
> timestamp with time zone
> );
>
> create rule test_rule_a as
> on insert to test do (
> insert into test_log ( anid, value, op, attime )
> values ( new.anid, new.value, 'insert', now() )
> );