1. 31 1月, 2007 5 次提交
    • B
      Add: · 99507b9a
      Bruce Momjian 提交于
      >
      > * Add REINDEX CONCURRENTLY, like CREATE INDEX CONCURRENTLY
      >
      >   This is difficult because you must upgrade to an exclusive table lock
      >   to replace the existing index file.  CREATE INDEX CONCURRENTLY does not
      >   have this complication.  This would allow index compaction without
      >   downtime.
      99507b9a
    • B
      Update for VACUUM FULL: · 62b2786b
      Bruce Momjian 提交于
      <   reindex rather than update the index.
      >   reindex rather than update the index.  Also, index updates can
      >   bloat the index.
      62b2786b
    • B
      Add: · aca00a8b
      Bruce Momjian 提交于
      > 	o ARRAY[[1,2],[3,4]])[1] should return the same values as
      > 	  ARRAY[[1,2],[3,4]])[1:1];
      >
      aca00a8b
    • B
      91a753f6
    • B
      Update documentation for backslashes to mention escape string syntax · 4ed9f1d9
      Bruce Momjian 提交于
      more, and standard_conforming_strings less, because in the future non-E
      strings will not treat backslashes specially.
      
      Also use E'' strings where backslashes are used in examples. (The
      existing examples would have drawn warnings.)
      
      Backpatch to 8.2.X.
      4ed9f1d9
  2. 30 1月, 2007 3 次提交
  3. 29 1月, 2007 1 次提交
  4. 28 1月, 2007 1 次提交
  5. 27 1月, 2007 7 次提交
  6. 26 1月, 2007 2 次提交
  7. 25 1月, 2007 10 次提交
    • B
      Update pg_dumpall -f option description. · 167fa70a
      Bruce Momjian 提交于
      167fa70a
    • P
      Various fixes in the logic of XML functions: · 22bd156f
      Peter Eisentraut 提交于
      - Add new SQL command SET XML OPTION (also available via regular GUC) to
        control the DOCUMENT vs. CONTENT option in implicit parsing and
        serialization operations.
      
      - Subtle corrections in the handling of the standalone property in
        xmlroot().
      
      - Allow xmlroot() to work on content fragments.
      
      - Subtle corrections in the handling of the version property in
        xmlconcat().
      
      - Code refactoring for producing XML declarations.
      22bd156f
    • B
      Done: · 9597446d
      Bruce Momjian 提交于
      > 	o -Add a GUC variable to control the tablespace for temporary objects
      9597446d
    • B
      Add GUC temp_tablespaces to provide a default location for temporary · 148ea5cb
      Bruce Momjian 提交于
      objects.
      
      Jaime Casanova
      148ea5cb
    • B
      Add 'output file' option for pg_dumpall, especially useful for Win32, · 6441288e
      Bruce Momjian 提交于
      where output redirection of child processes (pg_dump) doesn't work.
      
      Dave Page
      6441288e
    • B
      Remove developers list from TODO list now that we have URLs to reference · 1b7d863f
      Bruce Momjian 提交于
      discussions.
      
      <
      <
      < ---------------------------------------------------------------------------
      <
      <
      < Developers who have claimed items are:
      < --------------------------------------
      < * Alvaro is Alvaro Herrera <alvherre@dcc.uchile.cl>
      < * Andrew is Andrew Dunstan <andrew@dunslane.net>
      < * Bruce is Bruce Momjian <bruce@momjian.us> of EnterpriseDB
      < * Christopher is Christopher Kings-Lynne <chriskl@familyhealth.com.au> of
      <     Family Health Network
      < * D'Arcy is D'Arcy J.M. Cain <darcy@druid.net> of The Cain Gang Ltd.
      < * David is David Fetter <david@fetter.org>
      < * Fabien is Fabien Coelho <coelho@cri.ensmp.fr>
      < * Gavin is Gavin Sherry <swm@linuxworld.com.au> of Alcove Systems Engineering
      < * Greg is Greg Sabino Mullane <greg@turnstep.com>
      < * Jan is Jan Wieck <JanWieck@Yahoo.com> of Afilias, Inc.
      < * Joe is Joe Conway <mail@joeconway.com>
      < * Karel is Karel Zak <zakkr@zf.jcu.cz>
      < * Magnus is Magnus Hagander <mha@sollentuna.net>
      < * Marc is Marc Fournier <scrappy@hub.org> of PostgreSQL, Inc.
      < * Matthew T. O'Connor <matthew@zeut.net>
      < * Michael is Michael Meskes <meskes@postgresql.org> of Credativ
      < * Neil is Neil Conway <neilc@samurai.com>
      < * Oleg is Oleg Bartunov <oleg@sai.msu.su>
      < * Pavel is Pavel Stehule <pavel.stehule@hotmail.com>
      < * Peter is Peter Eisentraut <peter_e@gmx.net>
      < * Philip is Philip Warner <pjw@rhyme.com.au> of Albatross Consulting Pty. Ltd.
      < * Rod is Rod Taylor <pg@rbt.ca>
      < * Simon is Simon Riggs <simon@2ndquadrant.com>
      < * Stephan is Stephan Szabo <sszabo@megazone23.bigpanda.com>
      < * Tatsuo is Tatsuo Ishii <ishii@sraoss.co.jp> of SRA OSS, Inc. Japan
      < * Teodor is Teodor Sigaev <teodor@sigaev.ru>
      < * Tom is Tom Lane <tgl@sss.pgh.pa.us> of Red Hat
      1b7d863f
    • B
      Done: · 7aa09c5d
      Bruce Momjian 提交于
      < 	o Add -f to pg_dumpall
      > 	o -Add -f to pg_dumpall
      7aa09c5d
    • B
      Allow pg_dumpall to specify a database name rather than the default · d37881fd
      Bruce Momjian 提交于
      'template1'.
      
      Dave Page
      d37881fd
    • B
      Add --tablespaces-only and --roles-only options to pg_dumpall. · 5ce94b28
      Bruce Momjian 提交于
      Dave Page
      5ce94b28
    • B
      Prevent WAL logging when COPY is done in the same transation that · ef65f6f7
      Bruce Momjian 提交于
      created it.
      
      Simon Riggs
      ef65f6f7
  8. 24 1月, 2007 1 次提交
  9. 23 1月, 2007 2 次提交
  10. 22 1月, 2007 2 次提交
    • B
      eeae929d
    • T
      Add COST and ROWS options to CREATE/ALTER FUNCTION, plus underlying pg_proc · 5a7471c3
      Tom Lane 提交于
      columns procost and prorows, to allow simple user adjustment of the estimated
      cost of a function call, as well as control of the estimated number of rows
      returned by a set-returning function.  We might eventually wish to extend this
      to allow function-specific estimation routines, but there seems to be
      consensus that we should try a simple constant estimate first.  In particular
      this provides a relatively simple way to control the order in which different
      WHERE clauses are applied in a plan node, which is a Good Thing in view of the
      fact that the recent EquivalenceClass planner rewrite made that much less
      predictable than before.
      5a7471c3
  11. 21 1月, 2007 6 次提交