db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak" <tom...@gmail.com>
Subject Re: schema mix up !
Date Tue, 02 Jan 2007 03:24:00 GMT
On 12/26/06, Laurent ROCHE <laurent_roche@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

Mime
View raw message