Re: Ant <sql> tag for dollar quoting

From: "Jason Bennett" <jasonab(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Ant <sql> tag for dollar quoting
Date: 2006-12-18 21:34:22
Message-ID: 1166477662.327464.174080@73g2000cwn.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Finally figured this one out.

Ant eats double-$$ as part of its variable processing. You have to use
$BODY$ (or similar) in the stored procs, and put the delimiter on its
own line (with delimitertype="row"). Ant will cooperate then.

Jason Bennett wrote:
> With the new JDBC driver out, I was hopeful I could finally load my
> entire database through my build file, using the <sql> tag.
> Unfortunately, someone is still eating one of the $ marks, causing an
> error.

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter Neu 2006-12-19 10:18:36 Re: Efficient Insert statement for one record into multiple
Previous Message Tom Lane 2006-12-18 19:55:49 Re: pg_clog