RE: postgres stored procedure sql task problem

2006-05-19 Thread Anderson, Rob (Global Trade)
. -Rob A > -Original Message- > From: Gareth Reakes [mailto:[EMAIL PROTECTED] > 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 work

Re: postgres stored procedure sql task problem

2006-05-19 Thread Scot P. Floess
help, Gareth Anderson, Rob (Global Trade) wrote: Can you post the portion of your build.xml that produces the error you mention below. -Rob A -Original Message- From: Gareth Reakes [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 16, 2006 9:15 AM To: Ant Users List Subject: postgres stored

Re: postgres stored procedure sql task problem

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

RE: postgres stored procedure sql task problem

2006-05-17 Thread Anderson, Rob (Global Trade)
uesday, 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.PSQ

Re: postgres stored procedure sql task problem

2006-05-17 Thread Gareth Reakes
t the portion of your build.xml that produces the error you mention below. -Rob A -Original 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 en

Re: postgres stored procedure sql task problem

2006-05-17 Thread Scot P. Floess
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 lin

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
Hey, I have tried both referencing it but file with the src attribute and by putting in the sql tag. The file works with the -f option on the command line with psql (also with redirection in). Cheers, Gareth Scot P. Floess wrote: Sorry sounds like smart alec question...but there is not

postgres stored procedure sql task problem

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

RE: postgres stored procedure sql task problem

2006-05-16 Thread Anderson, Rob (Global Trade)
Can you post the portion of your build.xml that produces the error you mention below. -Rob A > -Original 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 prob

Re: postgres stored procedure sql task problem

2006-05-16 Thread Scot P. Floess
I seem to remember having some issue creating stored procs and tables, etc defined in a file with the task. I think what I had to do is escape each line like: create proc foo; \ ... \ ... Of course disregard the terrible markup above ;) Its been quite a few years so I don't remember all the

Re: postgres stored procedure sql task problem

2006-05-16 Thread Gareth Reakes
Hey, I have tried both referencing it by file with the src attribute and by putting in the sql tag. The file works with the -f option on the command line with psql (also with redirection). Cheers, Gareth Scot P. Floess wrote: Sorry sounds like smart alec question...but there is not ind

Re: postgres stored procedure sql task problem

2006-05-16 Thread Scot P. Floess
Sorry sounds like smart alec question...but there is not 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

Re: postgres stored procedure sql task problem

2006-05-16 Thread Scot P. Floess
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 sucking in a stored procedure. I works fine on the command line to psql but gives the error o

postgres stored procedure sql task problem

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