1. 22 Mar, 2009 3 commits
  2. 21 Mar, 2009 1 commit
    • Tom Lane's avatar
      Optimize multi-batch hash joins when the outer relation has a nonuniform · 596efd27
      Tom Lane authored
      distribution, by creating a special fast path for the (first few) most common
      values of the outer relation.  Tuples having hashvalues matching the MCVs
      are effectively forced to be in the first batch, so that we never write
      them out to the batch temp files.
      
      Bryce Cutt and Ramon Lawrence, with some editorialization by me.
      596efd27
  3. 20 Mar, 2009 1 commit
  4. 18 Mar, 2009 6 commits
  5. 17 Mar, 2009 4 commits
  6. 15 Mar, 2009 2 commits
    • Tom Lane's avatar
      Fix contrib/hstore to throw an error for keys or values that don't fit in its · f3a72bd4
      Tom Lane authored
      data structure, rather than silently truncating them.  Andrew Gierth
      f3a72bd4
    • Tom Lane's avatar
      Clean up the code for to_timestamp's conversion of year plus ISO day number · 7a52a8f8
      Tom Lane authored
      to date, as per bug #4702 and subsequent discussion.  In particular, make it
      work for years specified using AD/BC or CC fields, and fix the test for "no
      year specified" so that it doesn't trigger inappropriately for 1 BC (which it
      was doing even in code paths that had nothing to do with to_timestamp).  I
      also did some minor code beautification in the non-ISO-day-number code path.
      
      This area has been busted all along, but because the code has been rewritten
      repeatedly, it would be considerable trouble to back-patch.  It's such a
      corner case that it doesn't seem worth the effort.
      7a52a8f8
  7. 13 Mar, 2009 2 commits
  8. 12 Mar, 2009 2 commits
  9. 11 Mar, 2009 4 commits
  10. 10 Mar, 2009 4 commits
    • Tom Lane's avatar
      Make SubPlan nodes carry the result's typmod as well as datatype OID. This is · dcf3902f
      Tom Lane authored
      for consistency with the (relatively) recent addition of typmod to SubLink.
      An example of why it's a good idea is to be seen in the recent "failed to
      locate grouping columns" bug, which wouldn't have happened if a SubPlan
      exposed the same typmod info as the SubLink it was derived from.
      
      This could be back-patched, since it doesn't affect any on-disk data format,
      but for the moment it doesn't seem necessary to do so.
      dcf3902f
    • Tom Lane's avatar
      Fix set_subquery_pathlist() to copy the RTE's subquery before it gets mangled · 4886dc92
      Tom Lane authored
      by the planning process.  This prevents the "failed to locate grouping columns"
      error recently reported by Dickson Guedes.  That happens because planning
      replaces SubLinks by SubPlans in the subquery's targetlist, and exprTypmod()
      is smarter about the former than the latter, causing the apparent type of
      the subquery's output columns to change.  This seems to be a deficiency we
      should fix in exprTypmod(), but that will be a much more invasive patch
      with possible side-effects elsewhere, so I'll do that only in HEAD.
      
      Back-patch to 8.3.  Arguably the lack of a copying step is broken/dangerous
      all the way back, but in the absence of known problems I'll refrain from
      making the older branches pay the extra cost.  (The reason this particular
      symptom didn't appear before is that exprTypmod() wasn't smart about SubLinks
      either, until 8.3.)
      4886dc92
    • Teodor Sigaev's avatar
      Prevent recursion during parse of email-like string with multiple '@'. · 42831729
      Teodor Sigaev authored
      Patch by Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
      42831729
    • Bruce Momjian's avatar
      Doc patch for the recently added probes. · b0c68c24
      Bruce Momjian authored
      Robert Lor
      b0c68c24
  11. 09 Mar, 2009 5 commits
  12. 08 Mar, 2009 4 commits
  13. 07 Mar, 2009 2 commits