| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | cvs | 2005-01-07 15:18:42 | CVS Commit by andreas: fix closing QueryTool if FindDlg still open |
| Previous Message | cvs | 2005-01-07 14:40:21 | CVS Commit by andreas: fix quoting identifiers starting with numbers |