Return-Path: 
 <torque-dev-return-4112-apmail-db-torque-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-dev-archive@www.apache.org
Received: (qmail 4012 invoked from network); 21 Apr 2004 22:23:25 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 21 Apr 2004 22:23:25 -0000
Received: (qmail 47765 invoked by uid 500); 21 Apr 2004 22:23:12 -0000
Delivered-To: apmail-db-torque-dev-archive@db.apache.org
Received: (qmail 47562 invoked by uid 500); 21 Apr 2004 22:23:10 -0000
Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-dev-unsubscribe@db.apache.org>
List-Subscribe: <mailto:torque-dev-subscribe@db.apache.org>
List-Help: <mailto:torque-dev-help@db.apache.org>
List-Post: <mailto:torque-dev@db.apache.org>
List-Id: "Apache Torque Developers List" <torque-dev.db.apache.org>
Reply-To: "Apache Torque Developers List" <torque-dev@db.apache.org>
Delivered-To: mailing list torque-dev@db.apache.org
Received: (qmail 15547 invoked from network); 21 Apr 2004 21:57:41 -0000
Date: Wed, 21 Apr 2004 22:57:47 +0100 (BST)
From: Shevek <shevek@anarres.org>
X-X-Sender: shevek@astray.com
To: torque-dev@db.apache.org
Subject: Sequence bug in Postgres
Message-ID: <Pine.LNX.4.58.0404212254250.21887@astray.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Sender: Shevek <shevek@astray.com>
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

File DBPostgres.java

    /**
     * @param name The name of the field (should be of type
     *      <code>String</code>).
     * @return SQL to retreive the next database key.
     * @see org.apache.torque.adapter.DB#getIDMethodSQL(Object)
     */
    public String getIDMethodSQL(Object name)
    {
        return ("select currval('" + name + "')");
    }

This should clearly be nextval not currval. This unfortunately makes 
PostgreSQL unusable with Torque until fixed. Oracle, SAP, etc do not have 
this bug.

Please Cc me in any important replies. (Or perhaps just to let me know
that someone has seen this?) Many more of these and I probably have to
join the list anyway.

Oh, and postgres isn't capable of upgrading itself using the
project-schema.sql script since it doesn't drop things in the right order.  
No patch for this yet.

S.

-- 
Shevek                                    http://www.anarres.org/
I am the Borg.                         http://www.gothnicity.org/

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org