Hey Rob,
Thanks for help. The problem is this works fine if I pipe it into psql
on the command line which suggests to me that ant is going something to
the file prior to giving to psql. Maybe I will have a dig into the code
and see.
Cheers,
Gareth
Anderson, Rob (Global Trade) wrote:
Since Ant is not throwing the exception, I don't think there is a
problem with your usage of the sql task. I would suggest asking in a
postgresql forum.
Sorry I cannot offer more help.
-Rob A
-----Original Message-----
From: Gareth Reakes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 16, 2006 8:27 AM
To: Ant Users List
Subject: postgres stored procedure sql task problem
Hi all,
I am having a problem sucking in a stored procedure. I
works fine on the command line to psql but gives the error
org.postgresql.util.PSQLException: ERROR: unterminated
dollar-quoted string at or near $update_track_rating_average$
DECLARE
current_average_rating FLOAT"
The first few lines of the stored procedure are:
CREATE OR REPLACE FUNCTION update_track_rating_average()
RETURNS TRIGGER AS $update_track_rating_average$
DECLARE
current_average_rating FLOAT;
number_of_ratings BIGINT;
old_rating SMALLINT;
new_rating SMALLINT;
BEGIN
-- get current average rating / number of ratings
SELECT INTO current_average_rating average_rating FROM
tracks WHERE track_id = OLD.track_id;
SELECT INTO number_of_ratings ratings FROM tracks
WHERE track_id = OLD.track_id;
-- rating removed / updated
IF (TG_OP = 'DELETE' OR TG_OP = 'UPDATE') THEN
I have played with delimiter, delimitertype, escapeprocessing
and keepformat with no luck. Can anyone offer some advice?
Cheers,
Gareth
--
Gareth Reakes, Managing Director Parthenon Computing
+44-1865-811184 http://www.parthcomp.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Gareth Reakes, Managing Director Embrace Mobile
+44-1865-811197 http://www.embracemobile.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
