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 Fri, 19 May 2006 16:51:12 GMT
Ah, a common misconception. Ant does not pass this to psql, but rather
uses jdbc to connect to the database using the java drivers for
postgresql. While this may seem like the same thing, it really isnt.
Most (if not all) of the proprietary functionality of tools like psql
and sqlplus are lost.

-Rob A 

> -----Original Message-----
> From: Gareth Reakes [mailto:gareth@embracemobile.com] 
> Sent: Thursday, May 18, 2006 1:17 AM
> To: Ant Users List
> Subject: Re: postgres stored procedure sql task problem
> 
> 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:gareth@parthcomp.com]
> >> 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: 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
> > 
> > 
> 
> -- 
> Gareth Reakes, Managing Director           Embrace Mobile
> +44-1865-811197              http://www.embracemobile.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