Re: Rules and views (was Re: [HACKERS] Rules: 2nd patch) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Rules and views (was Re: [HACKERS] Rules: 2nd patch)
Date
Msg-id 199808191756.NAA04184@candle.pha.pa.us
Whole thread Raw
In response to Rules and views (was Re: [HACKERS] Rules: 2nd patch)  (jwieck@debis.com (Jan Wieck))
Responses Re: Rules and views (was Re: [HACKERS] Rules: 2nd patch)  (jwieck@debis.com (Jan Wieck))
List pgsql-hackers
>     If nobody votes against, I would like to make  them  builtins
>     as  pg_get_ruledef()  and pg_get_viewdef() and then setup the
>     appropriate views  (pg_rule  and  pg_view)  in  template1  by
>     initdb  like we do it with pg_user. It cannot break anything,
>     except that a rule action the  two  functions  cannot  handle
>     will  make  the new views unusable.  But it would be a really
>     powerful possibility for pg_dump or just useful to  see  what
>     that damn event qual and parsetree's in pg_rewrite came from.
>
>     Comments?
>

Go, Jan, go.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

pgsql-hackers by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Rules and views (was Re: [HACKERS] Rules: 2nd patch)
Next
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: Rules and views (was Re: [HACKERS] Rules: 2nd patch)