On Fri, 4 May 2007, B. Jordan wrote:
> After digging through the archives and looking at the changelog for
> 8.2-505 and 8.2-504, it seems that $$ should work, but I'm still
> getting errors.
>
> Here's the error message:
> Caused by: org.postgresql.util.PSQLException: ERROR: unterminated
> dollar-quoted string at or near "$BODY$ BEGIN DELETE FROM ..."
>
> Any particular reason I shouldn't be able to execute that with the
> latest version (8.2-505) of the driver?
Are you sure you don't have multiple versions of the driver around and
it's selecting an older version? The error above is exactly what I'd
expect to see with a pre-8.2 driver. You could also enable statement
logging on the server to see exactly what the driver is sending to it.
Kris Jurka