db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Einsle (JIRA)" <j...@apache.org>
Subject [jira] Erstellt: (DDLUTILS-49) Problem Delimiter in Postgres (8.1)
Date Fri, 18 Nov 2005 08:43:41 GMT
Problem Delimiter in Postgres (8.1)
-----------------------------------

         Key: DDLUTILS-49
         URL: http://issues.apache.org/jira/browse/DDLUTILS-49
     Project: DdlUtils
        Type: Bug
 Environment: DDL-Utils (svn-Version), Postgres 8.1, Jdbc-Driver of Postgres 8.1 Distribution.
    Reporter: Robert Einsle
 Assigned to: Thomas Dudziak 


while using DDL-Utils on Postgres 8.1 i found the following situation:

-- the xml ---
<database name="test">
 <table name="transactions">
   <column name="trade_id" primaryKey="true" required="true" type="INTEGER" size="4" autoIncrement="true"
/>
   <column name="currency" type="CHAR" size="3" />
   <column name="product" type="CHAR" size="4" />
   <column name="description" type="VARCHAR" size="50" />
   <column name="exchange" type="CHAR" size="15" />
   <column name="quantity" type="INTEGER" size="4" />
   <column name="price" type="NUMERIC" size="15,4" />
   <column name="amount" type="NUMERIC" size="15,2" />
   <column name="symbol" type="CHAR" size="5" />
   <column name="securityid" type="INTEGER" size="4" />
   <index name="idx_transactions_product">
     <index-column name="product"/>
   </index>
 </table>
</database>
--- end xml ---
while creating an Table ddl-utils reports the creating of the Sequence. But when creating
the Table i recived the following Error:

--- cut ---
... failed with ERROR: column "transactions_trade_id_seq" does not exist
--- cut ---

--- generated SQL ---
CREATE TABLE "transactions"
(
   "trade_id" INTEGER NOT NULL UNIQUE DEFAULT nextval("transactions_trade_id_seq"),
   "currency" CHAR(3),
   "product" CHAR(4),
   "description" VARCHAR(50),
   "exchange" CHAR(15),
   "quantity" INTEGER,
   "price" NUMERIC(15,4),
   "amount" NUMERIC(15,2),
   "symbol" CHAR(5),
   "securityid" INTEGER
)
--- end SQL

On Documentation of Postgres i found this:

--- Psql Doc ---

CREATE SEQUENCE /tablename/_/colname/_seq;
CREATE TABLE /tablename/ (
   /colname/ integer DEFAULT nextval('/tablename/_/colname/_seq') NOT NULL
);
--- end Doc ---

So i think the dopple Quotes in nextval should be single Quotes.




-- 
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


Mime
View raw message