Date: Tue, 21 Feb 2012 15:51:30 -0500
From: Ron Peterson <rpeterso@mtholyoke.edu>
To: pgsql-sql@postgresql.org
Subject: on insert rule with default value
Message-ID: <20120221205130.GG29194@mtholyoke.edu>
Mail-Followup-To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Organization: Mount Holyoke College
User-Agent: Mutt/1.5.20 (2009-06-14)

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?

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() )
);

-- 
Ron Peterson
Network & Systems Administrator
Mount Holyoke College
http://www.mtholyoke.edu/~rpeterso