Skip site navigation (1) Skip section navigation (2)

Re: Bug regarding SQL identifiers

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Alexander Borkowski <alexander(dot)borkowski(at)abri(dot)une(dot)edu(dot)au>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Bug regarding SQL identifiers
Date: 2005-01-07 14:41:10
Message-ID: 41DE9F86.3040502@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-hackers
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

In response to

pgadmin-hackers by date

Next:From: cvsDate: 2005-01-07 15:18:42
Subject: CVS Commit by andreas: fix closing QueryTool if FindDlg still open
Previous:From: cvsDate: 2005-01-07 14:40:21
Subject: CVS Commit by andreas: fix quoting identifiers starting with numbers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group