Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting? - Mailing list pgsql-jdbc

From GEISINGER Marc - Contractor
Subject Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting?
Date
Msg-id 5077_1348672047_50631A2F_5077_14708_1_E4DFA2E3210FA443B032684B39D16BB4092FB673D5@THSNCOA06MXS02P.ONE-06.GRP
Whole thread Raw
In response to Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting?  ("David Johnston" <polobo@yahoo.com>)
Responses Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting?  (Florent Guillaume <fg@nuxeo.com>)
List pgsql-jdbc

-----Ursprüngliche Nachricht-----
Von: David Johnston [mailto:polobo@yahoo.com]
Gesendet: Mittwoch, 26. September 2012 16:58
An: GEISINGER Marc - Contractor; 'Dave Cramer'
Cc: pgsql-jdbc@postgresql.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
thequery unmodified. 

Since $ in identifiers are postgres-only, there is no reason to try to be postgres-indepentend with SQL escape codes. I
thinkyour suggestion would be ok to handle dollar quotes. 

Marc



pgsql-jdbc by date:

Previous
From: GEISINGER Marc - Contractor
Date:
Subject: Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting?
Next
From: pprotim
Date:
Subject: Not able to insert array of integers into column of type integer array