| From: | GEISINGER Marc - Contractor <Marc(dot)GEISINGER(at)external(dot)thalesgroup(dot)com> |
|---|---|
| To: | David Johnston <polobo(at)yahoo(dot)com>, 'Dave Cramer' <pg(at)fastcrypt(dot)com> |
| Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting? |
| Date: | 2012-09-26 15:07:25 |
| Message-ID: | 5077_1348672047_50631A2F_5077_14708_1_E4DFA2E3210FA443B032684B39D16BB4092FB673D5@THSNCOA06MXS02P.ONE-06.GRP |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
-----Ursprüngliche Nachricht-----
Von: David Johnston [mailto:polobo(at)yahoo(dot)com]
Gesendet: Mittwoch, 26. September 2012 16:58
An: GEISINGER Marc - Contractor; 'Dave Cramer'
Cc: pgsql-jdbc(at)postgresql(dot)org
Betreff: RE: [JDBC] Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting?
> Which is why my suggestion is possibly superior and at least simpler (thus less prone to bugs).
> Once you find the non-conforming dollar-quote start tag in the query simply abort the JDBC specific code and return the query unmodified.
Since $ in identifiers are postgres-only, there is no reason to try to be postgres-indepentend with SQL escape codes. I think your suggestion would be ok to handle dollar quotes.
Marc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pprotim | 2012-09-26 15:41:03 | Not able to insert array of integers into column of type integer array |
| Previous Message | David Johnston | 2012-09-26 14:58:07 | Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting? |