1. 06 Jan, 2011 3 commits
  2. 05 Jan, 2011 8 commits
  3. 04 Jan, 2011 2 commits
  4. 03 Jan, 2011 5 commits
  5. 02 Jan, 2011 3 commits
    • Peter Eisentraut's avatar
      Implement remaining fields of information_schema.sequences view · 39b88432
      Peter Eisentraut authored
      Add new function pg_sequence_parameters that returns a sequence's start,
      minimum, maximum, increment, and cycle values, and use that in the view.
      (bug #5662; design suggestion by Tom Lane)
      
      Also slightly adjust the view's column order and permissions after review of
      SQL standard.
      39b88432
    • Robert Haas's avatar
      Fix typo. · e657b55e
      Robert Haas authored
      Noted by Magnus Hagander.
      e657b55e
    • Robert Haas's avatar
      Basic foreign table support. · 0d692a0d
      Robert Haas authored
      Foreign tables are a core component of SQL/MED.  This commit does
      not provide a working SQL/MED infrastructure, because foreign tables
      cannot yet be queried.  Support for foreign table scans will need to
      be added in a future patch.  However, this patch creates the necessary
      system catalog structure, syntax support, and support for ancillary
      operations such as COMMENT and SECURITY LABEL.
      
      Shigeru Hanada, heavily revised by Robert Haas
      0d692a0d
  6. 01 Jan, 2011 8 commits
  7. 31 Dec, 2010 4 commits
    • Bruce Momjian's avatar
      Include the first valid listen address in pg_ctl to improve server start · 30aeda43
      Bruce Momjian authored
      "wait" detection and add postmaster start time to help determine if the
      postmaster is actually using the specified data directory.
      30aeda43
    • Tom Lane's avatar
      Invert and rename flag variable to improve code readability. · 39c8dd66
      Tom Lane authored
      No change in functionality.  Per discussion with Robert.
      39c8dd66
    • Tom Lane's avatar
      Move symbols for ExecMergeJoin's state machine into nodeMergejoin.c. · 7b464015
      Tom Lane authored
      There's no reason for these values to be known anywhere else.  After
      doing this, executor/execdefs.h is vestigial and can be removed.
      7b464015
    • Tom Lane's avatar
      Support RIGHT and FULL OUTER JOIN in hash joins. · f4e4b327
      Tom Lane authored
      This is advantageous first because it allows us to hash the smaller table
      regardless of the outer-join type, and second because hash join can be more
      flexible than merge join in dealing with arbitrary join quals in a FULL
      join.  For merge join all the join quals have to be mergejoinable, but hash
      join will work so long as there's at least one hashjoinable qual --- the
      others can be any condition.  (This is true essentially because we don't
      keep per-inner-tuple match flags in merge join, while hash join can do so.)
      
      To do this, we need a has-it-been-matched flag for each tuple in the
      hashtable, not just one for the current outer tuple.  The key idea that
      makes this practical is that we can store the match flag in the tuple's
      infomask, since there are lots of bits there that are of no interest for a
      MinimalTuple.  So we aren't increasing the size of the hashtable at all for
      the feature.
      
      To write this without turning the hash code into even more of a pile of
      spaghetti than it already was, I rewrote ExecHashJoin in a state-machine
      style, similar to ExecMergeJoin.  Other than that decision, it was pretty
      straightforward.
      f4e4b327
  8. 30 Dec, 2010 2 commits
  9. 29 Dec, 2010 5 commits
    • Bruce Momjian's avatar
      Doc wording improvement: taken -> accepted · 0be88f87
      Bruce Momjian authored
           with time zone</type>.)  <type>timestamptz</type> is accepted as an
      0be88f87
    • Tom Lane's avatar
      Improve pg_upgrade's checks for required executables. · 88c80345
      Tom Lane authored
      Don't insist on pg_dumpall and psql being present in the old cluster,
      since they are not needed.  Do insist on pg_resetxlog being present
      (in both old and new), since we need it.  Also check for pg_config,
      but only in the new cluster.  Remove the useless attempt to call
      pg_config in the old cluster; we don't need to know the old value of
      --pkglibdir.  (In the case of a stripped-down migration installation
      there might be nothing there to look at anyway, so any future change
      that might reintroduce that need would have to be considered carefully.)
      
      Per my attempts to build a minimal previous-version installation to support
      pg_upgrade.
      88c80345
    • Robert Haas's avatar
      Bump XLOG_PAGE_MAGIC. · d2bc1c99
      Robert Haas authored
      The unlogged tables patch (commit 53dbc27c,
      2010-12-29) should have done this, since it changes the format of an
      XLOG_SMGR_CREATE record.
      d2bc1c99
    • Robert Haas's avatar
      Support unlogged tables. · 53dbc27c
      Robert Haas authored
      The contents of an unlogged table are WAL-logged; thus, they are not
      available on standby servers and are truncated whenever the database
      system enters recovery.  Indexes on unlogged tables are also unlogged.
      Unlogged GiST indexes are not currently supported.
      53dbc27c
    • Magnus Hagander's avatar
      Add REPLICATION privilege for ROLEs · 9b8aff8c
      Magnus Hagander authored
      This privilege is required to do Streaming Replication, instead of
      superuser, making it possible to set up a SR slave that doesn't
      have write permissions on the master.
      
      Superuser privileges do NOT override this check, so in order to
      use the default superuser account for replication it must be
      explicitly granted the REPLICATION permissions. This is backwards
      incompatible change, in the interest of higher default security.
      9b8aff8c