logo       
Google Custom Search
    AddThis Social Bookmark Button

Re: Bug regarding SQL identifiers: msg#00006

Subject: Re: Bug regarding SQL identifiers
Alexander Borkowski wrote:
Dear all,

I tried to look at some tables created by another tool whose name starts with a number (e.g. 100_something) with pgAdmin III 1.2.0. Doing this raises a PostgreSQL syntax error. I traced the cause to the needsQuoting function in src/utils/misc.cpp. According to the PostgreSQL documentation SQL identifiers are to be quoted if they don't start with a-z or an underbar, in particular numbers as first characters are not allowed. Attached you will find a patch which fixes this.

Good catch, thanks for reporting. Fix applied to CVS

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend




Try Searching:
servers, voip, java, networking, microsoft ...
<Prev in Thread] Current Thread [Next in Thread>