Skip to content
Snippets Groups Projects
  1. Jun 05, 2009
  2. Jun 04, 2009
  3. Jun 03, 2009
  4. Jun 02, 2009
    • Tom Lane's avatar
      Remove the old advice to keep from_collapse_limit less than geqo_threshold, · ade91586
      Tom Lane authored
      instead just pointing out that a larger value may trigger use of GEQO.
      Per Robert Haas.
      
      In passing, do a bit of wordsmithing on the Genetic Query Optimizer section.
      ade91586
    • Heikki Linnakangas's avatar
      Only recycle normal files in pg_xlog as WAL segments. pg_standby creates · 7c8d7a2e
      Heikki Linnakangas authored
      symbolic links with the -l option, and as Fujii Masao pointed out we ended up
      overwriting files in the archive directory before this patch. Patch by
      Aidan Van Dyk, Fujii Masao and me.
      
      Backpatch to 8.3, where pg_standby was introduced.
      7c8d7a2e
    • Joe Conway's avatar
      Fix dblink_get_result() as reported by Oleksiy Shchukin. Refactor a bit · db020733
      Joe Conway authored
      while we're at it per request by Tom Lane. Specifically, don't try to
      perform dblink_send_query() via dblink_record_internal() -- it was
      inappropriate and ugly.
      db020733
    • Tom Lane's avatar
      Change AdjustIntervalForTypmod to not discard higher-order field values on the · bac2ad38
      Tom Lane authored
      grounds that they don't fit into the specified interval qualifier (typmod).
      This behavior, while of long standing, is clearly wrong per spec --- for
      example the value INTERVAL '999' SECOND means 999 seconds and should not be
      reduced to less than 60 seconds.
      
      In some cases there could be grounds to raise an error if higher-order field
      values are not given as zero; for example '1 year 1 month'::INTERVAL MONTH
      should arguably be taken as an error rather than equivalent to 13 months.
      However our internal representation doesn't allow us to do that in a fashion
      that would consistently reject all and only the cases that a strict reading
      of the spec would suggest.  Also, seeing that for example INTERVAL '13' MONTH
      will print out as '1 year 1 mon', we have to be careful not to create a
      situation where valid data will fail to dump and reload.  The present patch
      therefore takes the attitude of not throwing an error in any such case.
      We might want to revisit that in future but it would take more redesign
      than seems prudent in late beta.
      
      Per a complaint from Sebastien Flaesch and subsequent discussion.  While
      at other times we might have just postponed such an issue to the next
      development cycle, 8.4 already has changed the parsing of interval literals
      quite a bit in an effort to accept all spec-compliant cases correctly.
      This seems like a change that should be part of that rather than coming
      along later.
      bac2ad38
  5. Jun 01, 2009
    • Tom Lane's avatar
      Fix DecodeInterval to report an error for multiple occurrences of DAY, WEEK, · b3b89fd1
      Tom Lane authored
      YEAR, DECADE, CENTURY, or MILLENIUM fields, just as it always has done for
      other types of fields.  The previous behavior seems to have been a hack to
      avoid defining bit-positions for all these field types in DTK_M() masks,
      rather than something that was really considered to be desired behavior.
      But there is room in the masks for these, and we really need to tighten up
      at least the behavior of DAY and YEAR fields to avoid unexpected behavior
      associated with the 8.4 changes to interpret ambiguous fields based on the
      interval qualifier (typmod) value.  Per my example and proposed patch.
      b3b89fd1
  6. May 31, 2009
  7. May 29, 2009
  8. May 28, 2009
  9. May 27, 2009
  10. May 26, 2009
  11. May 25, 2009
  12. May 24, 2009
    • Tom Lane's avatar
      Fix LIKE's special-case code for % followed by _. I'm not entirely sure that · fc2660fc
      Tom Lane authored
      this case is worth a special code path, but a special code path that gets
      the boundary condition wrong is definitely no good.  Per bug #4821 from
      Andrew Gierth.
      
      In passing, clean up some minor code formatting issues (excess parentheses
      and blank lines in odd places).
      
      Back-patch to 8.3, where the bug was introduced.
      fc2660fc
  13. May 21, 2009
Loading