.
-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
What if you escape the $ signs?
Gareth Reakes wrote:
Hi Scot,
thanks for your response. I have tried both in the file and in the
sql tag. I get an error in both cases.
Cheers,
Gareth
Scot P. Floess wrote:
Gareth:
My apologies, I meant escaping when it exists in another file. I
neve
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:
Sinc
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, 2
Hi Scot,
thanks for your response. I have tried both in the file and in the sql
tag. I get an error in both cases.
Cheers,
Gareth
Scot P. Floess wrote:
Gareth:
My apologies, I meant escaping when it exists in another file. I never
actually included my SQL statements in my build script -
Gareth:
My apologies, I meant escaping when it exists in another file. I never
actually included my SQL statements in my build script - this was
probably 3 - 4 years ago when I was doing so.
Gareth Reakes wrote:
Hi,
Very simplified version:
CREATE OR REPLACE FUNCT
Hi,
Very simplified version:
CREATE OR REPLACE FUNCTION update_track_rating_average() RETURNS
TRIGGER AS $update_track_rating_average$ \
BEGIN \
RETURN NULL; \
END; \
lineEnding
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
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 problem
>
> Hi all,
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
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
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
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
13 matches
Mail list logo
