| From: | Alexander Borkowski <alexander(dot)borkowski(at)abri(dot)une(dot)edu(dot)au> |
|---|---|
| To: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
| Subject: | Bug regarding SQL identifiers |
| Date: | 2005-01-06 08:48:52 |
| Message-ID: | 41DCFB74.5050501@abri.une.edu.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
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.
Cheers,
Alex
| Attachment | Content-Type | Size |
|---|---|---|
| patch.txt | text/plain | 435 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | cvs | 2005-01-07 14:37:39 | CVS Commit by andreas: fix quoting identifiers starting with numbers |
| Previous Message | Andreas Pflug | 2005-01-04 17:15:42 | Re: BUG: pgDomain.cpp |