1. 28 Sep, 2008 2 commits
  2. 27 Sep, 2008 1 commit
  3. 26 Sep, 2008 2 commits
  4. 25 Sep, 2008 1 commit
  5. 24 Sep, 2008 8 commits
  6. 23 Sep, 2008 5 commits
  7. 22 Sep, 2008 2 commits
    • Tom Lane's avatar
      Get rid of pgpass_from_client tracking inside libpq --- given the conclusion · c52aab55
      Tom Lane authored
      that presence of the password in the conninfo string must be checked *before*
      risking a connection attempt, there is no point in checking it afterwards.
      This makes the specification of PQconnectionUsedPassword() a bit simpler
      and perhaps more generally useful, too.
      c52aab55
    • Tom Lane's avatar
      Fix dblink_connect() so that it verifies that a password is supplied in the · cae7ad90
      Tom Lane authored
      conninfo string *before* trying to connect to the remote server, not after.
      As pointed out by Marko Kreen, in certain not-very-plausible situations
      this could result in sending a password from the postgres user's .pgpass file,
      or other places that non-superusers shouldn't have access to, to an
      untrustworthy remote server.  The cleanest fix seems to be to expose libpq's
      conninfo-string-parsing code so that dblink can check for a password option
      without duplicating the parsing logic.
      
      Joe Conway, with a little cleanup by Tom Lane
      cae7ad90
  8. 21 Sep, 2008 1 commit
  9. 19 Sep, 2008 6 commits
  10. 17 Sep, 2008 4 commits
  11. 16 Sep, 2008 3 commits
    • Tom Lane's avatar
      Clean up a couple of weird corner cases in interval parsing: make -yyyy-mm be · b73c0c2a
      Tom Lane authored
      interpreted as expected (the sign should affect months too), and get rid of
      hard-wired assumption that unmarked signed values must be hours (if integers)
      or seconds (if floats).  The former was just a bug in my previous patch,
      while the latter may have made sense at one time but seems illogical now
      that we support determination of the units from typmod information.
      Ron Mayer and myself.
      b73c0c2a
    • Tom Lane's avatar
      Widen the nLocks counts in local lock tables from int to int64. This · 30df79a7
      Tom Lane authored
      forestalls potential overflow when the same table (or other object, but
      usually tables) is accessed by very many successive queries within a single
      transaction.  Per report from Michael Milligan.
      
      Back-patch to 8.0, which is as far back as the patch conveniently applies.
      There have been no reports of overflow in pre-8.3 releases, but clearly the
      risk existed all along.  (Michael's report suggests that 8.3 may consume lock
      counts faster than prior releases, but with no test case to look at it's hard
      to be sure about that.  Widening the counts seems a good future-proofing
      measure in any event.)
      30df79a7
    • Tom Lane's avatar
  12. 15 Sep, 2008 5 commits
    • Tom Lane's avatar
      Fix caching of foreign-key-checking queries so that when a replan is needed, · 1cd93560
      Tom Lane authored
      we regenerate the SQL query text not merely the plan derived from it.  This
      is needed to handle contingencies such as renaming of a table or column
      used in an FK.  Pre-8.3, such cases worked despite the lack of replanning
      (because the cached plan needn't actually change), so this is a regression.
      Per bug #4417 from Benjamin Bihler.
      1cd93560
    • Magnus Hagander's avatar
      Fix error messages from recent pg_hba parsing patch to use errcontext() · 448950b3
      Magnus Hagander authored
      to indicate where the error occurred.
      448950b3
    • Tom Lane's avatar
      Change hash indexes to store only the hash code rather than the whole indexed · 4adc2f72
      Tom Lane authored
      value.  This means that hash index lookups are always lossy and have to be
      rechecked when the heap is visited; however, the gain in index compactness
      outweighs this when the indexed values are wide.  Also, we only need to
      perform datatype comparisons when the hash codes match exactly, rather than
      for every entry in the hash bucket; so it could also win for datatypes that
      have expensive comparison functions.  A small additional win is gained by
      keeping hash index pages sorted by hash code and using binary search to reduce
      the number of index tuples we have to look at.
      
      Xiao Meng
      
      This commit also incorporates Zdenek Kotala's patch to isolate hash metapages
      and hash bitmaps a bit better from the page header datastructures.
      4adc2f72
    • Magnus Hagander's avatar
      Add missing quotes. · 440b3384
      Magnus Hagander authored
      440b3384
    • Magnus Hagander's avatar
      Parse pg_hba.conf in postmaster, instead of once in each backend for · 98723810
      Magnus Hagander authored
      each connection. This makes it possible to catch errors in the pg_hba
      file when it's being reloaded, instead of silently reloading a broken
      file and failing only when a user tries to connect.
      
      This patch also makes the "sameuser" argument to ident authentication
      optional.
      98723810