1. 22 Aug, 2006 4 commits
  2. 21 Aug, 2006 8 commits
    • Tom Lane's avatar
      Fix encrypted-LDAP support so that it doesn't cause the server to fail · 5405576a
      Tom Lane authored
      entirely on older Windows platforms without the needed library function.
      Magnus Hagander
      5405576a
    • Tom Lane's avatar
      Minor code rearrangement to save a few cycles in RI_FKey_check when · d7c310c1
      Tom Lane authored
      the subject tuple is already deleted: we need not open the pk_rel
      until after we check that.
      d7c310c1
    • Tom Lane's avatar
    • Tom Lane's avatar
      Make the server track an 'XID epoch', that is, maintain higher-order bits · 35af5422
      Tom Lane authored
      of the transaction ID counter.  Nothing is done with the epoch except to
      store it in checkpoint records, but this provides a foundation with which
      add-on code can pretend that XIDs never wrap around.  This is a severely
      trimmed and rewritten version of the xxid patch submitted by Marko Kreen.
      Per discussion, the epoch counter seems the only part of xxid that really
      needs to be in the core server.
      35af5422
    • Bruce Momjian's avatar
      Done: · 1054c380
      Bruce Momjian authored
      < 	o Add a function to support Parse/DescribeStatement capability
      > 	o -Add a function to support Parse/DescribeStatement capability
      1054c380
    • Bruce Momjian's avatar
      Remove items, not needed anymore: · fe5d2133
      Bruce Momjian authored
      < * %Disallow changing DEFAULT expression of a SERIAL column?
      <
      <   This should be done only if the existing SERIAL problems cannot be
      <   fixed.
      <
      < * %Disallow ALTER SEQUENCE changes for SERIAL sequences because pg_dump
      <   does not dump the changes
      fe5d2133
    • Michael Meskes's avatar
    • Tom Lane's avatar
      Fix all known problems with pg_dump's handling of serial sequences · 2b2a5072
      Tom Lane authored
      by abandoning the idea that it should say SERIAL in the dump.  Instead,
      dump serial sequences and column defaults just like regular ones.
      Add a new backend command ALTER SEQUENCE OWNED BY to let pg_dump recreate
      the sequence-to-column dependency that was formerly created "behind the
      scenes" by SERIAL.  This restores SERIAL to being truly "just a macro"
      consisting of component operations that can be stated explicitly in SQL.
      Furthermore, the new command allows sequence ownership to be reassigned,
      so that old mistakes can be cleaned up.
      
      Also, downgrade the OWNED-BY dependency from INTERNAL to AUTO, since there
      is no longer any very compelling argument why the sequence couldn't be
      dropped while keeping the column.  (This forces initdb, to be sure the
      right kinds of dependencies are in there.)
      
      Along the way, add checks to prevent ALTER OWNER or SET SCHEMA on an
      owned sequence; you can now only do this indirectly by changing the
      owning table's owner or schema.  This is an oversight in previous
      releases, but probably not worth back-patching.
      2b2a5072
  3. 20 Aug, 2006 2 commits
  4. 19 Aug, 2006 4 commits
  5. 18 Aug, 2006 9 commits
  6. 17 Aug, 2006 6 commits
    • Tom Lane's avatar
      Implement archive_timeout feature to force xlog file switches to occur no more · e8ea9e95
      Tom Lane authored
      than N seconds apart.  This allows a simple, if not very high performance,
      means of guaranteeing that a PITR archive is no more than N seconds behind
      real time.  Also make pg_current_xlog_location return the WAL Write pointer,
      add pg_current_xlog_insert_location to return the Insert pointer, and fix
      pg_xlogfile_name_offset to return its results as a two-element record instead
      of a smashed-together string, as per recent discussion.
      
      Simon Riggs
      e8ea9e95
    • Peter Eisentraut's avatar
      Produce a clean failure in configure when dtrace is selected but cannot be · bb764e94
      Peter Eisentraut authored
      found.  Besides stopping those early who have no dtrace installed
      whatsoever, this will also alert those who have dtrace in /usr/sbin, which
      might not be in the path, which would produce confusing failures much later
      in the build process.
      
      Add documentation about pointing configure to find dtrace.
      bb764e94
    • Tom Lane's avatar
      Fix an oversight in mergejoin planning: the planner would reject a · 92c651f8
      Tom Lane authored
      mergejoin possibility where the inner rel was less well sorted than
      the outer (ie, it matches some but not all of the merge clauses that
      can work with the outer), if the inner path in question is also the
      overall cheapest path for its rel.  This is an old bug, but I'm not
      sure it's worth back-patching, because it's such a corner case.
      Noted while investigating a test case from Peter Hardman.
      92c651f8
    • Tom Lane's avatar
      Teach convert_subquery_pathkeys() to handle the case where the · 144b0ae8
      Tom Lane authored
      subquery's pathkey is a RelabelType applied to something that appears
      in the subquery's output; for example where the subquery returns a
      varchar Var and the sort order is shown as that Var coerced to text.
      This comes up because varchar doesn't have its own sort operator.
      Per example from Peter Hardman.
      144b0ae8
    • Bruce Momjian's avatar
      Add: · 4e1bdcaa
      Bruce Momjian authored
      < * Add support for arrays of domains
      > 	o Add support for arrays of domains
      > 	o Add support for arrays of complex types
      4e1bdcaa
    • Bruce Momjian's avatar
      Add: · 565de20f
      Bruce Momjian authored
      > * Support a data type with specific enumerated values (ENUM)
      >
      >   http://archives.postgresql.org/pgsql-hackers/2006-08/msg00979.php
      565de20f
  7. 16 Aug, 2006 3 commits
  8. 15 Aug, 2006 4 commits
    • Tom Lane's avatar
      Add a hack so that get_type_io_data() can work from bootstrap.c's · 1395ac6c
      Tom Lane authored
      internal TypInfo table in bootstrap mode.  This allows array_in and
      array_out to be used during early bootstrap, which eliminates the
      former obstacle to giving OUT parameters to built-in functions.
      1395ac6c
    • Tom Lane's avatar
      Add hooks to allow debugging and performance measurement plugins · 355865c5
      Tom Lane authored
      to instrument PL/pgSQL.  Korry Douglas
      355865c5
    • Tom Lane's avatar
      Add server support for "plugin" libraries that can be used for add-on tasks · abc3120e
      Tom Lane authored
      such as debugging and performance measurement.  This consists of two features:
      a table of "rendezvous variables" that allows separately-loaded shared
      libraries to communicate, and a new GUC setting "local_preload_libraries"
      that allows libraries to be loaded into specific sessions without explicit
      cooperation from the client application.  To make local_preload_libraries
      as flexible as possible, we do not restrict its use to superusers; instead,
      it is restricted to load only libraries stored in $libdir/plugins/.  The
      existing LOAD command has also been modified to allow non-superusers to
      LOAD libraries stored in this directory.
      
      This patch also renames the existing GUC variable preload_libraries to
      shared_preload_libraries (after a suggestion by Simon Riggs) and does some
      code refactoring in dfmgr.c to improve clarity.
      
      Korry Douglas, with a little help from Tom Lane.
      abc3120e
    • Tatsuo Ishii's avatar
      Fix pgbench to handle empty lines in script files as documented. · 66541c5a
      Tatsuo Ishii authored
      patches contributed by Itagaki Takahiro.
      66541c5a