[BUGS] CURRENT_TIMESTAMP not work correctly insinde a transaction.

[Nicolas Paymal]

Hello
  I am using pgsql 7.1 and 7.2 and I found a bug When I use
CURRENT_TIMESTAMP in a sql query.
In a transaction until you commit your transaction through a jdbc
connection, each time you use the Current_timestamp (or 'now'), the
timestamps is always the same, and when your transaction is very long you
have undesirable effect.


I also would like to submit enhancement request, who can I contact or where
can I send e-mail ?

Thanks for you Help.

example of code :


import java.sql.*;

class test  {

   static private String driver = "org.postgresql.Driver";
   static private String url    =
"jdbc:postgresql://bela:5432/idb?compatible=7.1";

   static void main(String argv[]) {
      Connection con        = null;
      Statement  statement  = null;
      ResultSet  rset       = null;

      try {
         Class.forName(driver);
         con = DriverManager.getConnection(url, "iuser", "qa");
         statement = con.createStatement();
         con.setAutoCommit(false);
         int cpt;
         for (int i=0;i<5;i++) {
            rset = statement.executeQuery("SELECT CURRENT_TIMESTAMP AS
VAR");
            if (rset!=null && rset.next()) {
               java.sql.Timestamp ts = rset.getTimestamp("VAR");
               System.out.println(i + "  -> timestamp = "+ts);
            }
            Thread.sleep(1000);
         }

         con.commit();

         for (int i=0;i<5;i++) {
            rset = statement.executeQuery("SELECT CURRENT_TIMESTAMP AS
VAR");
            if (rset!=null && rset.next()) {
               java.sql.Timestamp ts = rset.getTimestamp("VAR");
               System.out.println((i+5) + "  -> timestamp = "+ts);
            }
            Thread.sleep(1000);
         }

         statement.close();
         con.close();
      } catch (Exception e) {
         System.out.println("# Problem: "+e);
         e.printStackTrace();
      }
   }
}

--
Nicolas Paymal
Developer R&D.
Instranet Inc.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly