[ http://issues.apache.org/jira/browse/DDLUTILS-126?page=all ]
Rusty Wright updated DDLUTILS-126:
----------------------------------
Affects Version/s: 1.0
(was: 1.1)
> 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
>
> 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:
> ==========
> <?xml version="1.0"?>
> <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database.dtd";>
> <database name="waitlist" defaultIdMethod="native">
> <table name="waitlist">
> <column name="waitlist_key"
> type="bigint"
> size="20"
> required="true"
> primaryKey="true"
> autoIncrement="true"
> />
> <column name="facility"
> type="varchar"
> size="20"
> required="true"
> />
> <column name="uid"
> type="varchar"
> size="16"
> required="true"
> />
> <column name="cn"
> type="varchar"
> size="40"
> required="true"
> />
> <column name="type"
> type="varchar"
> size="20"
> required="true"
> />
> <column name="platform"
> type="varchar"
> size="8"
> required="true"
> />
> <column name="signin_time"
> type="timestamp"
> required="true"
> />
> <unique name="uid_platform_facility">
> <unique-column name="uid" />
> <unique-column name="platform" />
> <unique-column name="facility" />
> </unique>
> </table>
> </database>
--
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
