From ddlutils-dev-return-1248-apmail-db-ddlutils-dev-archive=db.apache.org@db.apache.org Fri Dec 01 06:28:44 2006 Return-Path: Delivered-To: apmail-db-ddlutils-dev-archive@www.apache.org Received: (qmail 81797 invoked from network); 1 Dec 2006 06:28:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 1 Dec 2006 06:28:43 -0000 Received: (qmail 48810 invoked by uid 500); 1 Dec 2006 06:28:52 -0000 Delivered-To: apmail-db-ddlutils-dev-archive@db.apache.org Received: (qmail 48792 invoked by uid 500); 1 Dec 2006 06:28:52 -0000 Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-dev@db.apache.org Delivered-To: mailing list ddlutils-dev@db.apache.org Received: (qmail 48781 invoked by uid 99); 1 Dec 2006 06:28:52 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 30 Nov 2006 22:28:52 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 30 Nov 2006 22:28:43 -0800 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 060037142F7 for ; Thu, 30 Nov 2006 22:28:23 -0800 (PST) Message-ID: <2369000.1164954503021.JavaMail.jira@brutus> Date: Thu, 30 Nov 2006 22:28:23 -0800 (PST) From: "Thomas Dudziak (JIRA)" To: ddlutils-dev@db.apache.org Subject: [jira] Resolved: (DDLUTILS-126) errors about the sequence with postgresql In-Reply-To: <27971958.1156450700152.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ http://issues.apache.org/jira/browse/DDLUTILS-126?page=all ] Thomas Dudziak resolved DDLUTILS-126. ------------------------------------- Resolution: Fixed > errors about the sequence with postgresql > ----------------------------------------- > > Key: DDLUTILS-126 > URL: http://issues.apache.org/jira/browse/DDLUTILS-126 > Project: DdlUtils > Issue Type: Bug > Components: Core - PostgreSql > Affects Versions: 1.0 > Environment: Solaris 10, x86, java 1.5 > Reporter: Rusty Wright > Assigned To: Thomas Dudziak > Fix For: 1.0 > > > Ant output: > ========== > [ddlToDatabase] Read schema file /local_a/users/rusty/java/jwaitlistd10/sql/waitlist.xml > [ddlToDatabase] Aug 24, 2006 12:47:57 PM org.apache.ddlutils.alteration.ModelComparator compare > [ddlToDatabase] INFO: Table waitlist needs to be added > [ddlToDatabase] Aug 24, 2006 12:47:57 PM org.apache.ddlutils.platform.PlatformImplBase evaluateBatch > [ddlToDatabase] WARNING: SQL Command CREATE TABLE waitlist > [ddlToDatabase] ( > [ddlToDatabase] waitlist_key BIGINT NOT NULL UNIQUE DEFAULT nextval('waitlist_waitlist_key_seq'), > [ddlToDatabase] facility VARCHAR(20) NOT NULL, > [ddlToDatabase] uid VARCHAR(16) NOT NULL, > [ddlToDatabase] cn VARCHAR(40) NOT NULL, > [ddlToDatabase] type VARCHAR(20) NOT NULL, > [ddlToDatabase] platform VARCHAR(8) NOT NULL, > [ddlToDatabase] signin_time TIMESTAMP NOT NULL, > [ddlToDatabase] PRIMARY KEY (waitlist_key) > [ddlToDatabase] ) failed with: ERROR: relation "waitlist_waitlist_key_seq" does not exist > [ddlToDatabase] Aug 24, 2006 12:47:57 PM org.apache.ddlutils.platform.PlatformImplBase evaluateBatch > [ddlToDatabase] WARNING: SQL Command CREATE UNIQUE INDEX uid_platform_facility ON waitlist (uid, platform, facility) failed with: ERROR: relation "waitlist" does not exist > [ddlToDatabase] Aug 24, 2006 12:47:57 PM org.apache.ddlutils.platform.PlatformImplBase evaluateBatch > [ddlToDatabase] INFO: Executed 2 SQL command(s) with 2 error(s) > [ddlToDatabase] Written schema to database > [ddlToDatabase] Read schema file /local_a/users/rusty/java/jwaitlistd10/sql/waitlist2.xml > [ddlToDatabase] Written SQL to /local_a/users/rusty/java/jwaitlistd10/sql/waitlist2_generated.sql > ========== > waitlist.xml file: > ========== > > > > > type="bigint" > size="20" > required="true" > primaryKey="true" > autoIncrement="true" > /> > type="varchar" > size="20" > required="true" > /> > type="varchar" > size="16" > required="true" > /> > type="varchar" > size="40" > required="true" > /> > type="varchar" > size="20" > required="true" > /> > type="varchar" > size="8" > required="true" > /> > type="timestamp" > required="true" > /> > > > > > >
> > ========== > Lib directory where the jars are for its classpath: > ========== > DdlUtils-1.0-dev.jar > commons-beanutils-1.7.0.jar > commons-betwixt-0.8-dev.jar > commons-codec-1.3.jar > commons-collections-3.2.jar > commons-dbcp-1.2.1.jar > commons-digester-1.7.jar > commons-lang-2.1.jar > commons-logging-1.1.jar > commons-logging-adapters-1.1.jar > commons-pool-1.2.jar > jakarta-oro-2.0.8.jar > jtds-1.2.jar > mysql-connector-java-3.1.12-bin.jar > pgjdbc3.jar > stax-1.1.2-dev.jar > stax-api-1.0.jar > ========== -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira