db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From torque-...@db.apache.org
Subject [DB Torque Wiki] Updated: PostgreSQLFAQ
Date Thu, 22 Apr 2004 00:51:03 GMT
   Date: 2004-04-21T17:51:03
   Editor: ScottEade <seade@backstagetech.com.au>
   Wiki: DB Torque Wiki
   Page: PostgreSQLFAQ
   URL: http://wiki.apache.org/db-torque/PostgreSQLFAQ

   no comment

Change Log:

------------------------------------------------------------------------------
@@ -72,6 +72,12 @@
 
 While there are lots of problems with that snippet (such as the fact that the java produced
by subsequent the {{{maven torque:om}}} goal is buggy), perhaps this could be recognized as
calling the Postgresql internal function nextval [http://www.postgresql.org/docs/7.4/interactive/functions-sequence.html
Postgresql--Sequence-Manipulation Functions], and somehow link that with the ability to define
such calls in java, as in [http://www.postgresql.org/docs/7.4/interactive/jdbc-callproc.html
Postgresql--Calling Stored Functions].  Grepping the source tree, I saw calls to nextval in
the Oracle driver, but I didn't explore further.  Perhaps this code is similar?
 
+== When I examine the source code I see that the PostgreSQL currval() function is used for
idMethod='native' - this cannot possibly be right since it should quite obviously be using
nextval(). ==
+
+Please read the following thread in its entirety:
+ *  http://nagoya.apache.org/eyebrowse/ReadMsg?listName=torque-dev@db.apache.org&msgNo=3537
+The source also gives the impression that it is somehow using AUTOINCREMENT when SEQUENCE
would seem to be the more obvious choice.  This is more of an indication of whether or not
the id should be returned before or after the insert - the names of these things could certainly
be improved.
+
 == Do I need to patch the PostgreSQL driver to work with Torque? ==
 
 You do not need to apply any patches to the Postgres driver in order to use Torque <strong>unless</strong>

---------------------------------------------------------------------
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