ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Markus Mehrwald <mmehrw...@gmx.at>
Subject Ant SQL task
Date Thu, 03 Jun 2010 23:13:46 GMT
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


Mime
View raw message