Re: pg_rules view - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_rules view
Date
Msg-id 5306.1042302663@sss.pgh.pa.us
Whole thread Raw
In response to pg_rules view  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> 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.

That's by design.  pg_rules suppresses view rules.  You'll find asfd in
pg_views, instead.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: v7.3.1 psql against a v7.2.x database ...
Next
From: Bruce Momjian
Date:
Subject: Re: src/port/fseeko.c revision 1.9 broken on NetBSD