1. 31 Dec, 2008 3 commits
    • Tom Lane's avatar
      Consistently use multi-line formatting for all ACL columns printed by psql's · 6672daac
      Tom Lane authored
      various display commands, not only for \z.
      
      In passing, fix some infelicities in the newly added \d commands for SQL-MED
      catalogs.
      
      Andreas Scherbaum and Tom Lane
      6672daac
    • Tom Lane's avatar
      Add a WINDOW attribute to CREATE FUNCTION, and teach pg_dump about it, · 26ce4e85
      Tom Lane authored
      so that user-defined window functions are possible.  For the moment you'll
      have to write them in C, for lack of any interface to the WindowObject API
      in the available PLs, but it's better than no support at all.
      
      There was some debate about the best syntax for this.  I ended up choosing
      the "it's an attribute" position --- the other approach will inevitably be
      more work, and the likely market for user-defined window functions is
      probably too small to justify it.
      26ce4e85
    • Tom Lane's avatar
      Add some basic support for window frame clauses to the window-functions · 8e8854da
      Tom Lane authored
      patch.  This includes the ability to force the frame to cover the whole
      partition, and the ability to make the frame end exactly on the current row
      rather than its last ORDER BY peer.  Supporting any more of the full SQL
      frame-clause syntax will require nontrivial hacking on the window aggregate
      code, so it'll have to wait for 8.5 or beyond.
      8e8854da
  2. 30 Dec, 2008 3 commits
  3. 29 Dec, 2008 4 commits
  4. 28 Dec, 2008 1 commit
  5. 27 Dec, 2008 1 commit
    • Tom Lane's avatar
      Make a couple of small changes to the tuplestore API, for the benefit of the · 38e93482
      Tom Lane authored
      upcoming window-functions patch.  First, tuplestore_trim is now an
      exported function that must be explicitly invoked by callers at
      appropriate times, rather than something that tuplestore tries to do
      behind the scenes.  Second, a read pointer that is marked as allowing
      backward scan no longer prevents truncation.  This means that a read pointer
      marked as having BACKWARD but not REWIND capability can only safely read
      backwards as far as the oldest other read pointer.  (The expected use pattern
      for this involves having another read pointer that serves as the truncation
      fencepost.)
      38e93482
  6. 26 Dec, 2008 1 commit
  7. 24 Dec, 2008 1 commit
  8. 20 Dec, 2008 4 commits
  9. 19 Dec, 2008 5 commits
  10. 18 Dec, 2008 6 commits
  11. 17 Dec, 2008 3 commits
    • Michael Meskes's avatar
      Applied patch by ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> to · e05c5a90
      Michael Meskes authored
      fix segfault on non-glibc systems.
      e05c5a90
    • Heikki Linnakangas's avatar
      Don't reset pg_class.reltuples and relpages in VACUUM, if any pages were · dcf84099
      Heikki Linnakangas authored
      skipped. We could update relpages anyway, but it seems better to only
      update it together with reltuples, because we use the reltuples/relpages
      ratio in the planner. Also don't update n_live_tuples in pgstat.
      
      ANALYZE in VACUUM ANALYZE now needs to update pg_class, if the
      VACUUM-phase didn't do so. Added some boolean-passing to let analyze_rel
      know if it should update pg_class or not.
      
      I also moved the relcache invalidation (to update rd_targblock) from
      vac_update_relstats to where RelationTruncate is called, because
      vac_update_relstats is not called for partial vacuums anymore. It's more
      obvious to send the invalidation close to the truncation that requires it.
      
      Per report by Ned T. Crigler.
      dcf84099
    • Bruce Momjian's avatar
      The attached patch contains a couple of fixes in the existing probes and · 5a90bc1f
      Bruce Momjian authored
      includes a few new ones.
      
      - Fixed compilation errors on OS X for probes that use typedefs
      - Fixed a number of probes to pass ForkNumber per the relation forks
      patch
      - The new probes are those that were taken out from the previous
      submitted patch and required simple fixes. Will submit the other probes
      that may require more discussion in a separate patch.
      
      Robert Lor
      5a90bc1f
  12. 16 Dec, 2008 5 commits
  13. 15 Dec, 2008 3 commits