Re: [HACKERS] New TODO item - Mailing list pgsql-hackers

From wieck@debis.com (Jan Wieck)
Subject Re: [HACKERS] New TODO item
Date
Msg-id m10ujJm-0003kLC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to New TODO item  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] New TODO item
List pgsql-hackers
Bruce Momjian wrote:

>
> New item for TODO list:
>
> * SELECT aliname FROM pg_class aliname generates strange error
>
>
>    test=> SELECT aliname FROM pg_class aliname;
>    NOTICE:  unknown node tag 704 in rangeTableEntry_used()
>    NOTICE:  Node is: { IDENT "aliname" }
>    NOTICE:  unknown node tag 704 in fireRIRonSubselect()
>    NOTICE:  Node is: { IDENT "aliname" }
>    ERROR:  copyObject: don't know how to copy 704

    Without  looking  at  anything  I  can tell that these NOTICE
    messages got spit out of the rewriter (I  placed  them  there
    along with the additional NOTICE telling nodeToString()).

    It looks to me that the targetlist contains a bare identifier
    which the parser wasn't able to change into  a  Var  node  or
    something  else.  That  should  never  be  possible.  A valid
    querytree cannot contain identifiers where the parser  didn't
    knew from which rangetable entry they should come from.

    Look  at  the  parser  output  (-d4)  and you'll see the same
    problems the rewriter just told.


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: "D'Arcy" "J.M." Cain
Date:
Subject: This is weird
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] New TODO item