Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.0 RC1
    • Component/s: Core - PostgreSql
    • Labels:
      None
    • Environment:
      DDL-Utils (svn-Version), Postgres 8.1, Jdbc-Driver of Postgres 8.1 Distribution.

      Description

      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.

        Activity

        Robert Einsle created issue -
        Hide
        Thomas Dudziak added a comment -

        Fixed in SVN: now uses single quotes.

        Show
        Thomas Dudziak added a comment - Fixed in SVN: now uses single quotes.
        Thomas Dudziak made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Thomas Dudziak made changes -
        Component/s Core - PostgreSql [ 12311218 ]
        Thomas Dudziak made changes -
        Fix Version/s 1.0 RC1 [ 12312482 ]

          People

          • Assignee:
            Thomas Dudziak
            Reporter:
            Robert Einsle
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development