ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anderson, Rob (Global Trade)" <Rob.Ander...@nike.com>
Subject RE: postgres stored procedure sql task problem
Date Tue, 16 May 2006 21:23:55 GMT
Can you post the portion of your build.xml that produces the error you
mention below.

-Rob A 

> -----Original Message-----
> From: Gareth Reakes [mailto:gareth@parthcomp.com] 
> Sent: Tuesday, May 16, 2006 9:15 AM
> To: Ant Users List
> Subject: postgres stored procedure sql task problem
> 
> Hi all,
> 
> Apologies if this ends up being a duplicate - It seems this 
> email was not registered
> 
>      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: user-unsubscribe@ant.apache.org
> For additional commands, e-mail: user-help@ant.apache.org
> 
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Mime
View raw message