1. 19 Jan, 2001 13 commits
  2. 18 Jan, 2001 17 commits
    • Bruce Momjian's avatar
      Fix VAX ASM '1 f' -> '1f'. · c0a0f346
      Bruce Momjian authored
      c0a0f346
    • Bruce Momjian's avatar
      Oops. Remove extra semicolon in comment. · 77b347d2
      Bruce Momjian authored
      77b347d2
    • Bruce Momjian's avatar
      Update TODO list. · 27677416
      Bruce Momjian authored
      27677416
    • Vadim B. Mikheev's avatar
      0a127670
    • Peter Mount's avatar
      af8630f2
    • Peter Mount's avatar
      Thu Jan 18 17:37:00 GMT 2001 peter@retep.org.uk · 8bc9f001
      Peter Mount authored
              - Added new error message into errors.properties "postgresql.notsensitive"
                This is used by jdbc2.ResultSet when a method is called that should
                fetch the current value of a row from the database refreshRow() for
                example.
              - These methods no longer throw the not implemented but the new noupdate
                error. This is in preparation for the Updateable ResultSet support
                which will overide these methods by extending the existing class to
                implement that functionality, but needed to show something other than
                notimplemented:
                  moveToCurrentRow()
                  moveToInsertRow()
                  rowDeleted()
                  rowInserted()
                  all update*() methods, except those that took the column as a String
                  as they were already implemented to convert the String to an int.
              - getFetchDirection() and setFetchDirection() now throws
                "postgresql.notimp" as we only support one direction.
                The CursorResultSet will overide this when its implemented.
              - Created a new class under jdbc2 UpdateableResultSet which extends
                ResultSet and overides the relevent update methods.
                This allows us to implement them easily at a later date.
              - In jdbc2.Connection, the following methods are now implemented:
                  createStatement(type,concurrency);
                  getTypeMap();
                  setTypeMap(Map);
              - The JDBC2 type mapping scheme almost complete, just needs SQLInput &
                SQLOutput to be implemented.
              - Removed some Statement methods that somehow appeared in Connection.
              - In jdbc2.Statement()
                  getResultSetConcurrency()
                  getResultSetType()
                  setResultSetConcurrency()
                  setResultSetType()
              - Finally removed the old 6.5.x driver.
      8bc9f001
    • Peter Mount's avatar
      Thu Jan 18 12:24:00 GMT 2001 peter@retep.org.uk · 45b5d792
      Peter Mount authored
              - These methods in org.postgresql.jdbc2.ResultSet are now implemented:
                  getBigDecimal(int) ie: without a scale (why did this get missed?)
                  getBlob(int)
                  getCharacterStream(int)
                  getConcurrency()
                  getDate(int,Calendar)
                  getFetchDirection()
                  getFetchSize()
                  getTime(int,Calendar)
                  getTimestamp(int,Calendar)
                  getType()
                NB: Where int represents the column name, the associated version
                    taking a String were already implemented by calling the int
                    version.
              - These methods no longer throw the not implemented but the new noupdate
                error. This is in preparation for the Updateable ResultSet support
                which will overide these methods by extending the existing class to
                implement that functionality, but needed to show something other than
                notimplemented:
                  cancelRowUpdates()
                  deleteRow()
              - Added new error message into errors.properties "postgresql.noupdate"
                This is used by jdbc2.ResultSet when an update method is called and
                the ResultSet is not updateable. A new method notUpdateable() has been
                added to that class to throw this exception, keeping the binary size
                down.
              - Added new error message into errors.properties "postgresql.psqlnotimp"
                This is used instead of unimplemented when it's a feature in the
                backend that is preventing this method from being implemented.
              - Removed getKeysetSize() as its not part of the ResultSet API
      
      Thu Jan 18 09:46:00 GMT 2001 peter@retep.org.uk
              - Applied modified patch from Richard Bullington-McGuire
                <rbulling@microstate.com>. I had to modify it as some of the code
                patched now exists in different classes, and some of it actually
                patched obsolete code.
      
      Wed Jan 17 10:19:00 GMT 2001 peter@retep.org.uk
              - Updated Implementation to include both ANT & JBuilder
              - Updated README to reflect the changes since 7.0
      	- Created jdbc.jpr file which allows JBuilder to be used to edit the
                source. JBuilder _CAN_NOT_ be used to compile. You must use ANT for
                that. It's only to allow JBuilders syntax checking to improve the
                drivers source. Refer to Implementation for more details
      45b5d792
    • Hiroshi Inoue's avatar
      Fix some leaks(was my fault). · 89ac6439
      Hiroshi Inoue authored
      89ac6439
    • Thomas G. Lockhart's avatar
      Fix up "Postgres-style" time interval representation when fields have · 6acdebbd
      Thomas G. Lockhart authored
       mixed-signs. Previous effort left way too many minus signs, and was at
       least as broken as the one before that :(
      Clean up "ISO-style" time interval representation to omit zero fields if
       there is at least one non-zero field. Supress some leading plus signs
       when not necessary for clarity.
      Replace every #ifdef __CYGWIN__ block with a cleaner TIMEZONE_GLOBAL macro
       defined in datetime.h.
      6acdebbd
    • Thomas G. Lockhart's avatar
      6439de17
    • Thomas G. Lockhart's avatar
    • Tom Lane's avatar
      Fix performance issue with qualifications on VIEWs: outer query should · b06fbc7a
      Tom Lane authored
      try to push restrictions on the view down into the view subquery,
      so that they can become indexscan quals or what-have-you rather than
      being applied at the top level of the subquery.  7.0 and before were
      able to do this, though in a much klugier way, and I'd hate to have
      anyone complaining that 7.1 is stupider than 7.0 ...
      b06fbc7a
    • Thomas G. Lockhart's avatar
      7705581e
    • Bruce Momjian's avatar
      Add "OK, OK, Hiroshi's right" thread. · 78765435
      Bruce Momjian authored
      78765435
    • Hiroshi Inoue's avatar
      Change LockClassinfoForUpdate() to retry mark4update() in case · 53ebb228
      Hiroshi Inoue authored
      the tuple is already uodated. (If LockClassinfoForUpdate() is
      thought to be useful).
      53ebb228
    • Bruce Momjian's avatar
      Update TODO list. · 5322bf46
      Bruce Momjian authored
      5322bf46
    • Bruce Momjian's avatar
      Update TODO list. · 56e10b0e
      Bruce Momjian authored
      56e10b0e
  3. 17 Jan, 2001 6 commits
    • Bruce Momjian's avatar
      Functions -> Function's · 392793b1
      Bruce Momjian authored
      392793b1
    • Bruce Momjian's avatar
      attached is a patch that makes SysV semaphore emulation · 978c03f9
      Bruce Momjian authored
      using POSIX semaphores more robust on Darwin 1.2/Mac OS X
      Public Beta.  this is for the version of 7.1 available
      via anon cvs as of Jan 14 2001 14:00 PST.
      
      since the semaphores and shared memory created by this
      emulator are shared with the backends via fork(), their
      persistent names are not necessary.  removing their
      names with shm_unlink() and sem_unlink() after creation
      obviates the need for any "ipcclean" function.  further,
      without these changes, the shared memory (and, therefore,
      the semaphores) will not be re-initialized/re-created after
      the first execution of the postmaster, until reboot
      or until some (non-existent) ipcclean function is executed.
      
      this patch does the following:
      
         1) if the shared memory segment "SysV_Sem_Info" already
            existed, it is cleaned up.  it shouldn't be there anyways.
      
         2) the real indicator for whether the shared memory/semaphore
            emulator has been initialized is if "SemInfo" has been
            initialized.  the shared memory and semaphores must be
            initialized regardless of whether there was a garbage shared
            memory segment lying around.
      
         3) the shared memory segment "SysV_Sem_Info" is created with "O_EXCL"
            to catch the case where two postmasters might be starting
            simultaneously, so they don't both end up with the same shared
            memory (one will fail).  note that this can't be done with the
            semaphores because Darwin 1.2 has a bug where attempting to
            open an existing semaphore with "O_EXCL" set will ruin the
            semaphore until the next reboot.
      
         4) the shared memory segment "SysV_Sem_Info" is unlinked after
            it is created.  it will then exist without a name until the
            postmaster and all backend children exit.
         5) all semaphores are unlinked after they are created.  they'll
            then exist without names until the postmaster and all backend
            children exit.
      
      -michael thornburgh, zenomt@armory.com
      978c03f9
    • Bruce Momjian's avatar
      5088f074
    • Thomas G. Lockhart's avatar
      Change comparisons of tm->tm_isdst from "nonzero" to "greater than zero". · 8e984038
      Thomas G. Lockhart authored
       Not sure why some were this way, and others were already correct, but it
       seems to have been like this for several years.
      This caused problems on a few damaged platforms like AIX and IRIX which do
       not support DST calculations for years before 1970.
      Thanks to Andreas Zeugswetter <ZeugswetterA@wien.spardat.at> for finding
       the problem.
      8e984038
    • Bruce Momjian's avatar
      There are misprints in postgres doc., in : · 9a342d20
      Bruce Momjian authored
      Chapter 10. PL/pgSQL - SQL Procedural Language (c40914117.htm)
      
      Statements
      ...
      (resulting in a PL/pgSQL internal SELECT).
      But there are cases where someone isn't interested int
      -----------------------------------------(have to be)-->
      But there are cases where someone isn't interested in
           the functions result.
      
       RAISE level format''
      --(have to be)-->
       RAISE level 'format'
      9a342d20
    • Bruce Momjian's avatar
      Move structure comments from the top block down to the line entries for · 26e03211
      Bruce Momjian authored
      this file to match all the other files, and to be clearer.
      26e03211
  4. 16 Jan, 2001 3 commits
  5. 15 Jan, 2001 1 commit