[
https://jira.codehaus.org/browse/MSQL-36?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Robert Scholte closed MSQL-36.
------------------------------
Resolution: Fixed
Fix Version/s: 1.5
Fixed in [rev. 14468|http://fisheye.codehaus.org/changelog/mojo/?cs=14468]
> Document usage delimiter / delimiterType
> ----------------------------------------
>
> Key: MSQL-36
> URL: https://jira.codehaus.org/browse/MSQL-36
> Project: Maven 2.x SQL Plugin
> Issue Type: Improvement
> Affects Versions: 1.2, 1.3, 1.4
> Environment: postgresql (any version)
> sql-maven-plugin 1.2, 1.3
> Reporter: Igor Artamonov
> Assignee: Robert Scholte
> Fix For: 1.5
>
>
> When executing postgres-specific sql like this:
> {quote}
> CREATE OR REPLACE FUNCTION my_trig()
> RETURNS "trigger" AS
> $BODY$
> declare
> t text;
> begin
> -- any plpgsql code here, where each line ends with semicolon
> return NEW;
> end$BODY$
> LANGUAGE 'plpgsql' VOLATILE;
> {quote}
> it will cause an error:
> bq. ERROR: unterminated dollar-quoted string at or near "$BODY$declare t text
> It's because of SqlExecMojo.java which splits sql by ';', but all code
> between the $QUOTE$ and $QUOTE$ need to be parsed as one command at this case.
> As i know postgres jdbc driver already can parse code like this, and maybe
> you can make an investigation into it
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
