Re: postgres stored procedure sql task problem

2006-05-18 Thread Gareth Reakes
: 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

Re: postgres stored procedure sql task problem

2006-05-17 Thread Gareth Reakes
- this was probably 3 - 4 years ago when I was doing so. Gareth Reakes wrote: Hi, Very simplified version: CREATE OR REPLACE FUNCTION update_track_rating_average() RETURNS TRIGGER AS $update_track_rating_average$ \ BEGIN \ RETURN NULL

Re: postgres stored procedure sql task problem

2006-05-17 Thread Gareth Reakes
Message- From: Gareth Reakes [mailto:[EMAIL PROTECTED] 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

Re: postgres stored procedure sql task problem

2006-05-16 Thread Gareth Reakes
indication by what you mean when you say, "sucked in" Scot P. Floess wrote: Gareth: So, you are trying to "suck" this in via ant? Gareth Reakes wrote: Hi all, Apologies if this ends up being a duplicate - It seems this email was not registered I am having a

postgres stored procedure sql task problem

2006-05-16 Thread Gareth Reakes
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,

Re: postgres stored procedure sql task problem

2006-05-16 Thread Gareth Reakes
indication by what you mean when you say, "sucked in" Scot P. Floess wrote: Gareth: So, you are trying to "suck" this in via ant? Gareth Reakes wrote: Hi all, Apologies if this ends up being a duplicate - It seems this email was not registered I am having a problem

postgres stored procedure sql task problem

2006-05-16 Thread Gareth Reakes
sing 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-ma

apologies for multiple posts

2004-01-28 Thread Gareth Reakes
Sorry about that, I seem to be having some trouble with my mail client. Gareth - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: Sun One appserver 7 and iplanet-ejbc

2004-01-28 Thread Gareth Reakes
. Cheers, Gareth On Wed, 28 Jan 2004, Gareth Reakes wrote: > Hi all, > > I am trying to generate stubs for my ejb. I am using appserver 7. > I was hoping that the iplanet-ejbc would still be OK for me. It fails > with an IOException when trying to execute. This seems to be beca