1. 03 Jul, 2008 5 commits
  2. 01 Jul, 2008 11 commits
  3. 30 Jun, 2008 5 commits
  4. 29 Jun, 2008 1 commit
  5. 28 Jun, 2008 1 commit
  6. 27 Jun, 2008 7 commits
    • Tom Lane's avatar
      Consider a clause to be outerjoin_delayed if it references the nullable side · dcc23347
      Tom Lane authored
      of any lower outer join, even if it also references the non-nullable side and
      so could not get pushed below the outer join anyway.  We need this in case
      the clause is an OR clause: if it doesn't get marked outerjoin_delayed,
      create_or_index_quals() could pull an indexable restriction for the nullable
      side out of it, leading to wrong results as demonstrated by today's bug
      report from toruvinn.  (See added regression test case for an example.)
      
      In principle this has been wrong for quite a while.  In practice I don't
      think any branch before 8.3 can really show the failure, because
      create_or_index_quals() will only pull out indexable conditions, and before
      8.3 those were always strict.  So though we might have improperly generated
      null-extended rows in the outer join, they'd get discarded from the result
      anyway.  The gating factor that makes the failure visible is that 8.3
      considers "col IS NULL" to be indexable.  Hence I'm not going to risk
      back-patching further than 8.3.
      dcc23347
    • Magnus Hagander's avatar
      Fix standalone libpq build on win32. · f6c1dece
      Magnus Hagander authored
      Hiroshi Saito
      f6c1dece
    • Tom Lane's avatar
      Improve planner's estimation of the size of an append relation: rather than · 2c2161a4
      Tom Lane authored
      taking the maximum of any child rel's width, we should weight the widths
      proportionally to the number of rows expected from each child.  In hindsight
      this is obviously correct because row width is really a proxy for the total
      physical size of the relation.  Per discussion with Scott Carey (bug #4264).
      2c2161a4
    • Bruce Momjian's avatar
      Mention actual function names in documentation of how to pass binary · f95b5334
      Bruce Momjian authored
      values to libpq.
      f95b5334
    • Bruce Momjian's avatar
      Add to TODO: · 5d747ddd
      Bruce Momjian authored
      >
      > * Fix system views like pg_stat_all_tables to use set-returning
      >   functions, rather than views of per-column functions
      5d747ddd
    • Tom Lane's avatar
      Clarify plpgsql documentation by not treating IF THEN ELSE IF ... as a · 8530c82f
      Tom Lane authored
      truly distinct version of IF.  Per suggestion from Marko Kreen.
      8530c82f
    • Tom Lane's avatar
      Modify the recently-added probe for -Wl,--as-needed some more, because RHEL-4 · 623f8a09
      Tom Lane authored
      vintage Linux is even more broken than we realized: a link to libreadline
      will succeed, and fail only at runtime.  It seems that an AC_TRY_RUN test
      is the only reliable way to check whether this is really safe.  Per report
      from Tatsuo.
      623f8a09
  7. 26 Jun, 2008 10 commits