Skip to content
Snippets Groups Projects
  1. Oct 13, 2009
  2. Oct 12, 2009
  3. Oct 10, 2009
    • Tom Lane's avatar
      Improve similar_escape() in two different ways: · 05d24971
      Tom Lane authored
      * Stop escaping ? and {.  As of SQL:2008, SIMILAR TO is defined to have
      POSIX-compatible interpretation of ? as well as {m,n} and related constructs,
      so we should allow these things through to our regex engine.
      
      * Escape ^ and $.  It appears that our regex engine will treat ^^ at the
      beginning of the string the same as ^, and similarly for $$ at the end of
      the string, which meant that SIMILAR TO was effectively ignoring ^ at the
      start of the pattern and $ at the end.  Since these are not supposed to be
      metacharacters, this is a bug.
      
      The second part of this is arguably a back-patchable bug fix, but I'm
      hesitant to do that because it might break applications that are expecting
      something like "col SIMILAR TO '^foo$'" to work like a POSIX pattern.
      Seems safer to only change it at a major version boundary.
      
      Per discussion of an example from Doug Gorley.
      05d24971
    • Tom Lane's avatar
      Split the processing of INSERT/UPDATE/DELETE operations out of execMain.c. · 8a5849b7
      Tom Lane authored
      They are now handled by a new plan node type called ModifyTable, which is
      placed at the top of the plan tree.  In itself this change doesn't do much,
      except perhaps make the handling of RETURNING lists and inherited UPDATEs a
      tad less klugy.  But it is necessary preparation for the intended extension of
      allowing RETURNING queries inside WITH.
      
      Marko Tiikkaja
      8a5849b7
  4. Oct 09, 2009
    • Peter Eisentraut's avatar
      Use pg_get_triggerdef in pg_dump · b865d275
      Peter Eisentraut authored
      Add a variant of pg_get_triggerdef with a second argument "pretty" that
      causes the output to be formatted in the way pg_dump used to do.  Use this
      variant in pg_dump with server versions >= 8.5.
      
      This insulates pg_dump from most future trigger feature additions, such as
      the upcoming column triggers patch.
      
      Author: Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
      b865d275
  5. Oct 08, 2009
  6. Oct 06, 2009
  7. Oct 05, 2009
    • Tom Lane's avatar
      Create an ALTER DEFAULT PRIVILEGES command, which allows users to adjust · 249724cb
      Tom Lane authored
      the privileges that will be applied to subsequently-created objects.
      
      Such adjustments are always per owning role, and can be restricted to objects
      created in particular schemas too.  A notable benefit is that users can
      override the traditional default privilege settings, eg, the PUBLIC EXECUTE
      privilege traditionally granted by default for functions.
      
      Petr Jelinek
      249724cb
  8. Oct 04, 2009
  9. Oct 02, 2009
    • Tom Lane's avatar
      Fix erroneous handling of shared dependencies (ie dependencies on roles) · d691cb91
      Tom Lane authored
      in CREATE OR REPLACE FUNCTION.  The original code would update pg_shdepend
      as if a new function was being created, even if it wasn't, with two bad
      consequences: pg_shdepend might record the wrong owner for the function,
      and any dependencies for roles mentioned in the function's ACL would be lost.
      The fix is very easy: just don't touch pg_shdepend at all when doing a
      function replacement.
      
      Also update the CREATE FUNCTION reference page, which never explained
      exactly what changes and doesn't change in a function replacement.
      In passing, fix the CREATE VIEW reference page similarly; there's no
      code bug there, but the docs didn't say what happens.
      d691cb91
  10. Oct 01, 2009
  11. Sep 30, 2009
    • Tom Lane's avatar
      Assorted improvements in contrib/hstore. · 172eacba
      Tom Lane authored
      Remove the 64K limit on the lengths of keys and values within an hstore.
      (This changes the on-disk format, but the old format can still be read.)
      Add support for btree/hash opclasses for hstore --- this is not so much
      for actual indexing purposes as to allow use of GROUP BY, DISTINCT, etc.
      Add various other new functions and operators.
      
      Andrew Gierth
      172eacba
  12. Sep 29, 2009
  13. Sep 27, 2009
    • Tom Lane's avatar
      Extend the BKI infrastructure to allow system catalogs to be given · 49856352
      Tom Lane authored
      hand-assigned rowtype OIDs, even when they are not "bootstrapped" catalogs
      that have handmade type rows in pg_type.h.  Give pg_database such an OID.
      Restore the availability of C macros for the rowtype OIDs of the bootstrapped
      catalogs.  (These macros are now in the individual catalogs' .h files,
      though, not in pg_type.h.)
      
      This commit doesn't do anything especially useful by itself, but it's
      necessary infrastructure for reverting some ill-considered changes in
      relcache.c.
      49856352
  14. Sep 23, 2009
  15. Sep 22, 2009
  16. Sep 21, 2009
    • Tom Lane's avatar
      Define a new, more extensible syntax for COPY options. · 923413ac
      Tom Lane authored
      This is intentionally similar to the recently revised syntax for EXPLAIN
      options, ie, (name value, ...).  The old syntax is still supported for
      backwards compatibility, but we intend that any options added in future
      will be provided only in the new syntax.
      
      Robert Haas, Emmanuel Cecchet
      923413ac
  17. Sep 19, 2009
  18. Sep 18, 2009
  19. Sep 17, 2009
  20. Sep 14, 2009
  21. Sep 13, 2009
  22. Sep 12, 2009
  23. Sep 11, 2009
  24. Sep 10, 2009
  25. Sep 08, 2009
    • Tom Lane's avatar
      Add a boolean GUC parameter "bonjour" to control whether a Bonjour-enabled · eeb6cb14
      Tom Lane authored
      build actually attempts to advertise itself via Bonjour.  Formerly it always
      did so, which meant that packagers had to decide for their users whether
      this behavior was wanted or not.  The default is "off" to be on the safe
      side, though this represents a change in the default behavior of a
      Bonjour-enabled build.  Per discussion.
      eeb6cb14
Loading