db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shevek <she...@anarres.org>
Subject Sequence bug in Postgres
Date Wed, 21 Apr 2004 21:57:47 GMT
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


Mime
View raw message