Re-write rules on views

Поиск
Список
Период
Сортировка
Искать
От
Rip
Тема
Re-write rules on views
Дата
Msg-id
5.1.0.14.2.20020226192846.009ed850@mail.onlineinfo.net
Список
Дерево обсуждения
Re-write rules on views Rip <rip@onlineinfo.net>
Re: Re-write rules on views Tom Lane <tgl@sss.pgh.pa.us>
Re: Re-write rules on views Bruce Momjian <pgman@candle.pha.pa.us>
Re: Re-write rules on views Rip <rip@onlineinfo.net>

Hi all,
	The docs seem slim in this department.. what is the proper syntax for an 
update to a view with multiple tables?

Here's a view I'd like to update:

  CREATE VIEW "users_perms_view" AS
  	SELECT
  		 users.user_id,
		 users.username,
		 users.name_first,
		 users.name_last,
		 permissions.permission_name,
		 permissions.permission_description
  	FROM
  		 users,
		 users_permissions,
		 permissions
  	WHERE
  		 ((users_permissions.user_id = users.user_id) AND
		 (users_permissions.permission_id = permissions.permission_id));

This rule works fine as far as it goes:

CREATE RULE "update_users_perms_view" AS
	ON UPDATE TO users_perms_view DO INSTEAD
	UPDATE
		users SET
  		username = NEW.username,
		password = NEW.password,
		name_first = NEW.name_first,
		name_last = NEW.name_last,
		active = NEW.active,
	WHERE
		user_id = OLD.user_id;

How do I update the  users_permissions and  permissions table?

Thanx,

В списке pgsql-general по дате отправления
От: cbbrowne@acm.org
Дата:
От: Zak Greant
Дата:
FAQ