Re: Backend-internal SPI operations

Tom Lane wrote:
> >> The  right  way  IMHO would be to give views another relkind.
>
> > This appeals to me.
>
> I like it too.  Aside from the advantages Jan mentioned, we could also
> refrain from creating an underlying file for a view, which would be
> nice to avoid cluttering the database directory.

    From  memory  I think views are created as CREATE TABLE, with
    an internal  DefineRuleStmt,  and  dumped  as  CREATE  TABLE,
    CREATE  RULE for sure.  So the CREATE/DROP RULE would need to
    remove/recreate the tables file (plus toast file  and  index)
    if  you want it to be consistent. Don't think you want that -
    do you?


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #