1. 21 1月, 2007 11 次提交
  2. 20 1月, 2007 13 次提交
  3. 18 1月, 2007 5 次提交
  4. 17 1月, 2007 7 次提交
    • B
      3026e176
    • T
      Revise bgwriter fsync-request mechanism to improve robustness when a table · 6d660587
      Tom Lane 提交于
      is deleted.  A backend about to unlink a file now sends a "revoke fsync"
      request to the bgwriter to make it clean out pending fsync requests.  There
      is still a race condition where the bgwriter may try to fsync after the unlink
      has happened, but we can resolve that by rechecking the fsync request queue
      to see if a revoke request arrived meanwhile.  This eliminates the former
      kluge of "just assuming" that an ENOENT failure is okay, and lets us handle
      the fact that on Windows it might be EACCES too without introducing any
      questionable assumptions.  After an idea of mine improved by Magnus.
      
      The HEAD patch doesn't apply cleanly to 8.2, but I'll see about a back-port
      later.  In the meantime this could do with some testing on Windows; I've been
      able to force it through the code path via ENOENT, but that doesn't prove that
      it actually fixes the Windows problem ...
      6d660587
    • N
      vcbuild updates from Magnus: · 7f58ed1a
      Neil Conway 提交于
      * After Markos patch, now builds pgcrypto without zlib again
      * Updates README with xml info
      * xml requires xslt and iconv
      * disable unnecessary warning about __cdecl()
      * Add a buildenv.bat called from all other bat files to set up things
      like PATH for flex/bison. (Can't just set it before calling, doesn't
      always work when building from the GUI)
      7f58ed1a
    • N
      Implement width_bucket() for the float8 data type. · cf57ef4e
      Neil Conway 提交于
      The implementation is somewhat ugly logic-wise, but I don't see an
      easy way to make it more concise.
      
      When writing this, I noticed that my previous implementation of
      width_bucket() doesn't handle NaN correctly:
      
          postgres=# select width_bucket('NaN', 1, 5, 5);
           width_bucket
          --------------
                      6
          (1 row)
      
      AFAICS SQL:2003 does not define a NaN value, so it doesn't address how
      width_bucket() should behave here. The patch changes width_bucket() so
      that ereport(ERROR) is raised if NaN is specified for the operand or the
      lower or upper bounds to width_bucket(). For float8, NaN is disallowed
      for any of the floating-point inputs, and +/- infinity is disallowed
      for the histogram bounds (but allowed for the operand).
      
      Update docs and regression tests, bump the catversion.
      cf57ef4e
    • N
      Minor improvements to the TODO list. Add some URLs for some · da07c81f
      Neil Conway 提交于
      existing TODO items, and re-add a TODO item for an "estimated
      count" capability.
      da07c81f
    • T
      Fix incorrect permissions check in information_schema.key_column_usage view: · 6959cb59
      Tom Lane 提交于
      it was checking a pg_constraint OID instead of pg_class OID, resulting in
      "relation with OID nnnnn does not exist" failures for anyone who wasn't
      owner of the table being examined.  Per bug #2848 from Laurence Rowe.
      
      Note: for existing 8.2 installations a simple version update won't fix this;
      the easiest fix is to CREATE OR REPLACE this view with the corrected
      definition.
      6959cb59
    • A
      10a5e334
  5. 16 1月, 2007 2 次提交
  6. 15 1月, 2007 2 次提交