db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefan Huber (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-166) Column name 'language' causes errors during schema update
Date Wed, 21 Mar 2007 15:12:32 GMT
Column name 'language' causes errors during schema update

                 Key: DDLUTILS-166
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-166
             Project: DdlUtils
          Issue Type: Bug
          Components: Core - PostgreSql
         Environment: PostgreSQL v8.2 on Windows XP
            Reporter: Stefan Huber
         Assigned To: Thomas Dudziak

Create a database with the following schema definition (I did this via an ant task)

<?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
  <database name="mydb">
    <table name="ADDRESS">
      <column name="ID" primaryKey="true" required="true" type="INTEGER"/>
      <column name="language" primaryKey="false" required="false" type="VARCHAR" size="256"/>
      <index name="IDX_LANG">
	  <index-column name="language"/> 

If you perform an schema update with the same definition you get an error, that the index
column "language" could not be found in the table. Because of reasons I can only guess, the
jdbs driver returns the index column name "language" in quotes so that the column is not found
in the table definition.
This is a bit strange but even if the identifier "language" is a keyword in PostgreSQL it
is allowed as a column name and DdlUtils should consider this too.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message