Probable error on docs
От | Steve Howe |
---|---|
Тема | Probable error on docs |
Дата | |
Msg-id | 91lbbp$vfe$1@news.tht.net обсуждение исходный текст |
Ответы |
Re: Probable error on docs
|
Список | pgsql-docs |
Hi Folks, At programmer\rules1139.htm, (Rules on INSERT, UPDATE and DELETE), there are the following statments: CREATE TABLE shoelace_log ( sl_name char(10), -- shoelace changed sl_avail integer, -- new available value log_who name, -- who did it log_when datetime -- when ); CREATE RULE log_shoelace AS ON UPDATE TO shoelace_data WHERE NEW.sl_avail != OLD.sl_avail DO INSERT INTO shoelace_log VALUES ( NEW.sl_name, NEW.sl_avail, getpgusername(), 'now'::text ); In the RULE statment (the second one) there is a reference to a [shoelace_data] relation. Shouldn't it be the name of the table just created, [shoelace_log] ? In the RULE statment there is also a refernce to [shoelace_log]. I'm using the docs from the last snapshot. Files are dated 05/08/2000. Best Regards, Howe.
В списке pgsql-docs по дате отправления: