pg_rules view

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_rules view
Date: 2003-01-11 09:46:37
Message-ID: 20030111174528.K51890-100000@houston.familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2003-01-11 15:16:18 Re: v7.3.1 psql against a v7.2.x database ...
Previous Message Marc G. Fournier 2003-01-11 08:34:01 Re: v7.3.1 psql against a v7.2.x database ...