I was using a Java based front end to PG and tried to create a function
that I could use for a trigger.
CREATE OR REPLACE FUNCTION trg_func_ucase() RETURNS trigger AS
NEW.name = upper(NEW.name);
I kept getting an error message
ERROR: unterminated dollar-quoted string at or near "$trg$
As the statement works with psql, I thought this might be a problem of my
JDBC frontend, so I create a simple test program which sends the above
string using execute() (tried executeUpdate() as well) to the database, and
I'm getting the same error.
When I use single quotes around the function body everything works fine
through plain JDBC. This means a use disadvantage for any Java based
frontend (as I have to deal with the old clumsy quoting again), and I'm
wondering if this is a bug in the driver, or simply not supposed to work.
In any case: is there any chance of getting this fixed?
I'm using PG 8.0.2 on Win2000 and the JDBC driver is 8.0-311
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2005-05-23 22:05:02|
|Subject: Re: CREATE FUNCTION with JDBC|
|Previous:||From: Jarosław Jan Pyszny||Date: 2005-05-22 01:14:27|
|Subject: Translation update: pl_PL|