Updating a table via a view
От | Glen Eustace |
---|---|
Тема | Updating a table via a view |
Дата | |
Msg-id | 1044864423.6857.315.camel@agree-6 обсуждение исходный текст |
Ответы |
Re: Updating a table via a view
Re: Updating a table via a view |
Список | pgsql-general |
I am trying to maintain a history of rows. The base table has a start and end date. I am updating the table using a view and a rule. The rule, updates the end date on the current record and then inserts a new row with the modified columns, or at least thats what I want to happen. The update is occuring but the insert doesn't. I get no error but no row. The rule looks like this; CREATE RULE a_update AS ON UPDATE TO a DO INSTEAD (UPDATE a_hist SET tend = now() WHERE (a.x = old.x) AND (a.tend = 'infinity'::timestamptz); INSERT INTO a_hist ( x, tstart, tend, y, z ) VALUES ( new.x, now(), 'infinity'::timestamptz, new.y, new.z ); ); Any pointer as to what I am doing wrong ? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Glen and Rosanne Eustace, GodZone Internet Services, a division of AGRE Enterprises Ltd., P.O. Box 8020, Palmerston North, New Zealand 5301 Ph/Fax: +64 6 357 8168, Mob: +64 21 424 015
В списке pgsql-general по дате отправления: