Re: [HACKERS] VIEW definitions broken in 6.5.0 - Mailing list pgsql-hackers

From wieck@debis.com (Jan Wieck)
Subject Re: [HACKERS] VIEW definitions broken in 6.5.0
Date
Msg-id m116XR7-0003kvC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to VIEW definitions broken in 6.5.0  ("Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>)
List pgsql-hackers
>
> Hey hackers -
> I don't know if this is fixed in 6.5.1 or not, but the definition field
> in the pg_views system table is broken in 6.5.0, and this breaks view
> editing in pgaccess. The problem is that table qualifications are left
> off the fieldnames in both the SELECT clause and the WHERE clause. Minimal
> example given below:

Oh,

    I see the problem. It is because the rule backparsing utility
    prints the relation name only if it is referenced by  another
    name (... FROM t1 X, ...).

    I'll change it in the v6.5 tree to print it allways. For v6.6
    I'll work on rule recompilation which  requires  storing  the
    original query text and will avoid that problem entirely.


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) #

pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: CREATE VERSION
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Contributing