Delimiter for Postgres 8.1

[Robert Einsle <ro...@einsle.de>]

Hy List,

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.

Should i check the behavior on Postgres 7.4?

Re: Delimiter for Postgres 8.1

[Robert Einsle <ro...@einsle.de>]

Hy Tom,

is reported. Thanks for your Help.

\Robert

Thomas Dudziak schrieb:

>Sounds like a bug. Could you create an issue in JIRA ?
>
>Tom
>
>  
>

Re: Delimiter for Postgres 8.1

[Thomas Dudziak <to...@gmail.com>]

Sounds like a bug. Could you create an issue in JIRA ?

Tom