Skip site navigation (1) Skip section navigation (2)

CREATE FUNCTION with JDBC

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: CREATE FUNCTION with JDBC
Date: 2005-05-23 21:48:07
Message-ID: d6tivq$n9$1@sea.gmane.org (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hello,

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
$trg$
     BEGIN
          NEW.name = upper(NEW.name);
     END;
$trg$
language 'plpgsql';

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

Cheers
Thomas




Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2005-05-23 22:05:02
Subject: Re: CREATE FUNCTION with JDBC
Previous:From: Jarosław Jan PysznyDate: 2005-05-22 01:14:27
Subject: Translation update: pl_PL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group