Re: [HACKERS] create rule changes table to view ?

Peter Eisentraut wrote:

> A fix would be to display both tables and views as "relation". As far as I
> know there is now 100% deterministic way to tell a table from a view. I
> think one fine day Jan is going to change that but for now we don't have
> to worry about it.

    There is currently a 100% failsafe way.

    Actually,  rules  ON  SELECT  are totally restricted to rules
    that are INSTEAD, return  a  targetlist  that's  exactly  the
    relations  (views) schema and there could only be one single-
    action rule on the SELECT event. These checks  are  performed
    during CREATE RULE.

    In short: If there's a rule ON SELECT, then the relation MUST
    BE A VIEW.

    The detail psql is doing wrong is that it treats any rule  as
    if  it  is  indicating  a view. It must look for SELECT rules
    only.

    And I'm not planning to take out this restriction again.


Jan


--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #