You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ddlutils-user@db.apache.org by Thomas Dudziak <to...@gmail.com> on 2007/01/02 04:24:00 UTC

Re: schema mix up !

On 12/26/06, Laurent ROCHE <la...@yahoo.com> wrote:

> There is a little problem when doing an export of a PostgreSQL database where there is two schema (say public and queries).
>
> The generation of schema.xml is OK.
>
> But when generating data.xml DDL Utils will fail as it will try to read the content of tab1 in QUERIES with the SQL:
> select * from tab1
> instead of
> select * from queries.tab1

Please update DdlUtils and use both the schemapattern parameter
(http://db.apache.org/ddlutils/ant/org.apache.ddlutils.task.DatabaseToDdlTask.html#parameter-schemapattern)
and also set the new determineschema parameter to true
(http://db.apache.org/ddlutils/ant/org.apache.ddlutils.task.WriteDataToFileCommand.html#parameter-determineschema)

Tom