Return-Path: 
 <ddlutils-user-return-651-apmail-db-ddlutils-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org
Received: (qmail 81645 invoked from network); 12 May 2007 01:02:05 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 12 May 2007 01:02:05 -0000
Received: (qmail 13227 invoked by uid 500); 12 May 2007 01:02:11 -0000
Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org
Received: (qmail 13203 invoked by uid 500); 12 May 2007 01:02:11 -0000
Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:ddlutils-user-help@db.apache.org>
List-Unsubscribe: <mailto:ddlutils-user-unsubscribe@db.apache.org>
List-Post: <mailto:ddlutils-user@db.apache.org>
List-Id: <ddlutils-user.db.apache.org>
Reply-To: ddlutils-user@db.apache.org
Delivered-To: mailing list ddlutils-user@db.apache.org
Received: (qmail 13192 invoked by uid 99); 12 May 2007 01:02:11 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 May 2007 18:02:11 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: neutral (herse.apache.org: local policy)
Received: from [203.16.214.141] (HELO ipmail02.adl2.internode.on.net)
 (203.16.214.141)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 May 2007 18:02:03 -0700
X-IronPort-AV: E=Sophos;i="4.14,525,1170595800";
   d="scan'208";a="122233272"
Received: from hardlight.com.au (HELO [192.168.1.6]) ([203.122.246.130])
  by ipmail02.adl2.internode.on.net with ESMTP; 12 May 2007 10:31:38 +0930
Message-ID: <46451218.6070302@hardlight.com.au>
Date: Sat, 12 May 2007 10:32:16 +0930
From: Jason <jeacott@hardlight.com.au>
Reply-To: jeacott@hardlight.com.au
User-Agent: Thunderbird 1.5.0.8 (Windows/20061025)
MIME-Version: 1.0
To: ddlutils-user@db.apache.org
Subject: writeSchemaSqlToFile didnt work for me.
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

Hi all,
	I just checked out the latest head and built it (RC1), then ran it 
against a postgres 7.4 db. (This is the first time I have tried ddlutils 
after about 18 months!)
The writeSchemaToFile and writeDataToFile both produced output but 
writeSchemaSqlToFile produced an empty file.
I tried it with 2 drivers, pg74.216.jdbc3.jar, and 
postgresql-8.2dev-503.jdbc3.jar.

This is my Ant target:
         <target name="database-dump-postgres" description="Dumps the 
database structure" depends=$
           <taskdef name="databaseToDdl"
                  classname="org.apache.ddlutils.task.DatabaseToDdlTask">
             <classpath refid="runtime-classpath"/>
           </taskdef>
                 <delete dir="${database.backup.path}/src/schema"></delete>
                 <mkdir  dir="${database.backup.path}/src/schema"/>
  <databaseToDdl modelName="MyModel" databaseType="postgresql" 
useDelimitedSqlIdentifiers="true"/>
            <database 
url="jdbc:postgresql://${system.database.hostname}/${database.name}"
                       driverClassName="org.postgresql.Driver"
                           username="${database.user}"
                           password="${database.password}"/>
             <writeSchemaToFile 
outputFile="${database.backup.path}/src/schema/${database.backup.path}-schema.xml"/>

             <writeDataToFile
outputFile="${database.backup.path}/src/schema/${database.backup.path}-data.xml">
             </writeDataToFile>

             <writeSchemaSqlToFile
outputFile="${database.backup.path}/src/schema/${database.backup.path}-schema.sql">
</writeSchemaSqlToFile>
           </databaseToDdl>
         </target>

What I REALLY want is to be able to round trip this database back into 
postgres with all the same datatypes, but I'm not sure how I should do 
this. I think it should be a default option somewhere - eg dont mess 
with my db, just restore it please. specifically I a concerned about 
date field mappings (timestamptz should restore as timestamptz) and 
bytea->Blob/Clob->bytea (I think it produces 
bytea->Blob/Clob->longbinaryvarchar instead)


Hints/Thoughts greatly appreciated.
Jason.