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 "Robert Einsle (JIRA)" <ji...@apache.org> on 2005/11/18 09:43:41 UTC
[jira] Erstellt: (DDLUTILS-49) Problem Delimiter in Postgres (8.1)
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
[jira] Updated: (DDLUTILS-49) Problem Delimiter in Postgres (8.1)
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-49?page=all ]
Thomas Dudziak updated DDLUTILS-49:
-----------------------------------
Component: Core - PostgreSql
> Problem Delimiter in Postgres (8.1)
> -----------------------------------
>
> Key: DDLUTILS-49
> URL: http://issues.apache.org/jira/browse/DDLUTILS-49
> Project: DdlUtils
> Type: Bug
> Components: Core - PostgreSql
> 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
[jira] Resolved: (DDLUTILS-49) Problem Delimiter in Postgres (8.1)
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ 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