Re: question on update/delete rules on views

Поиск
Список
Период
Сортировка
От Brook Milligan
Тема Re: question on update/delete rules on views
Дата
Msg-id 200005171352.HAA19867@biology.nmsu.edu
обсуждение исходный текст
Ответ на question on update/delete rules on views  (Kyle Bateman <kyle@actarg.com>)
Список pgsql-sql
create rule view_a_r_update as on update to view_a   do instead       update a set two = new.two;

The problem is that your INSTEAD UPDATE rule is not constrained in any
way; it DOES hit every row.  Instead, do something like:
  create rule view_a_r_update as on update to view_a   do instead       update a set two = new.two       where id =
old.id;

where id is a primary key in your table.

Cheers,
Brook



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

Предыдущее
От: Yamini Sharma
Дата:
Сообщение: Storing binary data in a column
Следующее
От: "Mitch Vincent"
Дата:
Сообщение: Re: lower() for varchar data by creating an index