Strange constraint violation when applying rules to a view.

Поиск
Список
Период
Сортировка
От Peter Gebauer
Тема Strange constraint violation when applying rules to a view.
Дата
Msg-id 20040728134514.GA2669@bluefront.se
обсуждение исходный текст
Ответы Win32 binary  ("Glen Parker" <glenebob@nwlink.com>)
Список pgsql-general
Hello.

This section works fine:

CREATE TABLE torder (
        id      INT8 NOT NULL PRIMARY KEY
);

CREATE TABLE torder_row (
        id        INT8 NOT NULL PRIMARY KEY,
        torder_id INT8 NOT NULL REFERENCES torder (id) ON DELETE RESTRICT
);

CREATE VIEW vorder(orderID, rowID) AS SELECT 1, 1 FROM torder;

CREATE RULE vorder_ins AS ON INSERT TO vorder
  DO INSTEAD
  (INSERT INTO torder VALUES (NEW.orderID);
   INSERT INTO torder_row VALUES (NEW.rowID, NEW.orderID);
   );

CREATE RULE vorder_upd AS ON UPDATE TO vorder
  DO INSTEAD
  (INSERT INTO torder (id) VALUES (NEW.orderID);
   UPDATE torder_row SET torder_id = NEW.orderID;
   DELETE FROM torder WHERE id = OLD.orderID;
   );

INSERT INTO vorder VALUES (1, 1);
UPDATE vorder SET orderID = 2;
SELECT * FROM vorder;


But when I change the view to the following:

CREATE VIEW vorder(orderID, rowID) AS SELECT 1, 1 FROM torder;
becomes
CREATE VIEW vorder(orderID, rowID) AS SELECT id, 1 FROM torder;

I get the following error:
ERROR:  insert or update on table "torder_row" violates foreign key
constraint "$1"

This was just a small test so the table definitions and view makes
little sense, but generally, any time the view actualy selects columns
it seems the update rule fails with a constraint violation even though
it shouldn't.

Thank's for reading!
/Peter

В списке pgsql-general по дате отправления:

Предыдущее
От: John Sidney-Woollett
Дата:
Сообщение: Re: altering a starting value of "serial" macro
Следующее
От: Prabu Subroto
Дата:
Сообщение: Re: altering a starting value of "serial" macro