db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (DDLUTILS-49) Problem Delimiter in Postgres (8.1)
Date Mon, 21 Nov 2005 21:23:41 GMT
     [ http://issues.apache.org/jira/browse/DDLUTILS-49?page=all ]
     
Thomas Dudziak resolved DDLUTILS-49:
------------------------------------

    Resolution: Fixed

Fixed in SVN: now uses single quotes.

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