ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Markus Mehrwald <mmehrw...@gmx.at>
Subject Re: Ant SQL task
Date Thu, 03 Jun 2010 23:19:58 GMT
Sry, the sql function should be without begin and end:

CREATE OR REPLACE FUNCTION make_plpgsql() RETURNS void AS $$
CREATE LANGUAGE plpgsql;
$$ LANGUAGE sql;

Am 04.06.2010 01:13, schrieb Markus Mehrwald:
> Hi,
>
> I have a problem with the ant sql task. The task
> <sql classpathref="myclasspath"
> driver="org.postgresql.Driver"
> url="url"
> userid="user"
> password="password">
> <transaction src="db/Model.ddl"/>
> <transaction src="db/Trigger.sql"/>
> </sql>
>
> always gets the following error:
> [sql] Failed to execute: CREATE OR REPLACE FUNCTION make_plpgsql()
> RETURNS void AS $ BEGIN CREATE LANGUAGE plpgsql
>
> With the exception: Syntaxerror at "$"
> The script looks like this:
> CREATE OR REPLACE FUNCTION make_plpgsql() RETURNS void AS $$
> BEGIN
> CREATE LANGUAGE plpgsql;
> END
> $$ LANGUAGE sql;
>
> and it works with pgadmin3 and psql \i Trigger.sql without any errors.
> I tried with ant 1.7 and 1.8.1
>
> Thanks,
> Markus
>
> ---------------------------------------------------------------------
> 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