pg_rules view

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема pg_rules view
Дата
Msg-id 20030111174528.K51890-100000@houston.familyhealth.com.au
обсуждение исходный текст
Ответы Re: pg_rules view  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I tried creating a rule like:

create rule "_RETURN" as on select to asfd do instead select * from blah;

And it worked.

But it doesn't appear in pg_rules.

I created this one:

create rule myrule as on insert to asfd do instead nothing;

And it does appear:

test=# select * from pg_rules ;schemaname |  tablename  |   rulename    |
definition

------------+-------------+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------pg_catalog
|pg_settings | pg_settings_n | CREATE RULE pg_settings_n AS
 
ON UPDATE TO pg_settings DO INSTEAD NOTHING;pg_catalog | pg_settings | pg_settings_u | CREATE RULE pg_settings_u AS
ON UPDATE TO pg_settings WHERE (new.name = old.name) DO SELECT
set_config(old.name, new.setting, false) AS set_config;chriskl    | asfd        | myrule        | CREATE RULE myrule AS
ON
INSERT TO asfd DO INSTEAD NOTHING;
(3 rows)

What gives?

Chris




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

Предыдущее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: v7.3.1 psql against a v7.2.x database ...
Следующее
От: Robert Treat
Дата:
Сообщение: Re: v7.3.1 psql against a v7.2.x database ...