Re: new relkind for views - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: new relkind for views
Date
Msg-id 200009120449.AAA11103@candle.pha.pa.us
Whole thread Raw
In response to new relkind for views  (Mark Hollomon <mhh@mindspring.com>)
List pgsql-patches
Applied.  initdb all, catalog version updated.


>
> This patch implements a different "relkind"
> for views. Views are now have a "relkind" of
> RELKIND_VIEW instead of RELKIND_RELATION.
>
> Also, views no longer have actual heap storage
> files.
>
> The following changes were made
>
> 1. CREATE VIEW sets the new relkind
>
> 2. The executor complains if a DELETE or
>     INSERT references a view.
>
> 3. DROP RULE complains if an attempt is made
>     to delete a view SELECT rule.
>
> 4. CREATE RULE "_RETmytable" AS ON SELECT TO mytable DO INSTEAD ...
>     1. checks to make sure mytable is empty.
>     2. sets the relkind to RELKIND_VIEW.
>     3. deletes the heap storage files.
>
> 5. LOCK myview is not allowed. :)
>
>
> 6. the regression test type_sanity was changed to
>     account for the new relkind value.
>
> 7. CREATE INDEX ON myview ... is not allowed.
>
> 8. VACUUM myview is not allowed.
>     VACUUM automatically skips views when do the entire
>     database.
>
> 9. TRUNCATE myview is not allowed.
>
>
> THINGS LEFT TO THINK ABOUT
>
> o pg_views
>
> o pg_dump
>
> o pgsql (\d \dv)
>
> o Do we really want to be able to inherit from views?
>
> o Is 'DROP TABLE myview' OK?
>
> --
> Mark Hollomon
> mhh@mindspring.com

[ Attachment, skipping... ]


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Small SSL-related patch...
Next
From: Bruce Momjian
Date:
Subject: Re: Charset encoding patch to JDBC driver