1. 13 Jan, 2009 1 commit
  2. 12 Jan, 2009 6 commits
  3. 11 Jan, 2009 2 commits
  4. 10 Jan, 2009 5 commits
  5. 09 Jan, 2009 13 commits
  6. 08 Jan, 2009 7 commits
  7. 07 Jan, 2009 6 commits
    • Bruce Momjian's avatar
      Add comment about why BETWEEN uses operator strings and not opclasses, · ae3c0752
      Bruce Momjian authored
      with URL pointing to email discussion.
      ae3c0752
    • Tom Lane's avatar
      Create a third option named "partition" for constraint_exclusion, and make it · 445ce157
      Tom Lane authored
      the default.  This setting enables constraint exclusion checks only for
      appendrel members (ie, inheritance children and UNION ALL arms), which are
      the cases in which constraint exclusion is most likely to be useful.  Avoiding
      the overhead for simple queries that are unlikely to benefit should bring
      the cost down to the point where this is a reasonable default setting.
      Per today's discussion.
      445ce157
    • Bruce Momjian's avatar
      Have current_query() use ActivePortal->sourceText rather than · 12dcf7bb
      Bruce Momjian authored
      debug_query_string;  this allows current_query() to be more accurate;
      docs updated;  per idea from Tom
      12dcf7bb
    • Tom Lane's avatar
      Insert conditional SPI_push/SPI_pop calls into InputFunctionCall, · deac9488
      Tom Lane authored
      OutputFunctionCall, and friends.  This allows SPI-using functions to invoke
      datatype I/O without concern for the possibility that a SPI-using function
      will be called (which could be either the I/O function itself, or a function
      used in a domain check constraint).  It's a tad ugly, but not nearly as ugly
      as what'd be needed to make this work via retail insertion of push/pop
      operations in all the PLs.
      
      This reverts my patch of 2007-01-30 that inserted some retail SPI_push/pop
      calls into plpgsql; that approach only fixed plpgsql, and not any other PLs.
      But the other PLs have the issue too, as illustrated by a recent gripe from
      Christian Schröder.
      
      Back-patch to 8.2, which is as far back as this solution will work.  It's
      also as far back as we need to worry about the domain-constraint case, since
      earlier versions did not attempt to check domain constraints within datatype
      input.  I'm not aware of any old I/O functions that use SPI themselves, so
      this should be sufficient for a back-patch.
      deac9488
    • Bruce Momjian's avatar
      Add comment that it is difficult to access the more accurate · 6b883930
      Bruce Momjian authored
      'query_string' from current_query().
      6b883930
    • Bruce Momjian's avatar
      8faffe6a