You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Rusty Wright (JIRA)" <ji...@apache.org> on 2006/08/24 22:18:21 UTC
[jira] Updated: (DDLUTILS-126) errors about the sequence with
postgresql
[ http://issues.apache.org/jira/browse/DDLUTILS-126?page=all ]
Rusty Wright updated DDLUTILS-126:
----------------------------------
Description:
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>
was:
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>
> 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