on insert rule with default value
| От | Ron Peterson |
|---|---|
| Тема | on insert rule with default value |
| Дата | |
| Msg-id | 20120221205130.GG29194@mtholyoke.edu обсуждение исходный текст |
| Ответы |
Re: on insert rule with default value
|
| Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: