Thread: RULES

RULES

From
Fábio Santana
Date:
My friends, how i do to get a list of all rules in one table? Thanks!!!!



Re: RULES

From
Patrick Welche
Date:
On Tue, Nov 20, 2001 at 08:56:55PM -0300, Fábio Santana wrote:
> My friends, how i do to get a list of all rules in one table? Thanks!!!!

select rulename,definition from pg_rules where tablename='YourTable';

(Don't have any defined, so can't check)

I have a similar question on triggers:

create table a ( id    integer primary key
);

create table b ( a_id  integer references a(id) match full
);

select * from pg_trigger where tgname ~* '^RI_';

Gives me 3 rows. They all contain the same tgargs. Is it therefore
sufficient to select distinct tgnargs,tgargs if I just want to be able to
recreate the "references... match full" part of the create table statement?

It seems that the rows differ in

tgtype    tgrelid        tgconstrrelid    tgfoid9        table a        table b         RI_FKey_noaction_del
17        table a        table b            RI_FKey_noaction_upd
21        table b        table a            RI_FKey_check_ins

9=row,delete, 17=row,update, 21=row,insert,update ?

Why are the first 2 constraints there? It seems to be the last one which
says "If I insert,update table b, check it is a valid entry with table a"

Is that right?

Patrick