AW: Backend-internal SPI operations - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: Backend-internal SPI operations
Date
Msg-id 11C1E6749A55D411A9670001FA687963368062@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: Backend-internal SPI operations
List pgsql-hackers
>     The problem here is, that the relkind  must  change  at  rule
>     creation/drop  time.  Fortunately rules on SELECT are totally
>     restricted to VIEW's since 6.4, and I don't see any reason to
>     change this.

I don't see why a real view should still be createable by the old
create table then create rule way. Then the relkind would never 
need to change. The only place that would need correction is 
pg_dump to dump create view statements.

Imho we should not limit select rules to views by design.
With a different relkind for views this is not necessary anyway.

Andreas


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: More about "CREATE TABLE" from inside a function/trigger...
Next
From: Tom Lane
Date:
Subject: Re: func() & select func()