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.1
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
==========
waitlist2.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
