1. 03 10月, 2005 2 次提交
    • B
      Remove, 8.1 completed items already removed: · 6a175779
      Bruce Momjian 提交于
      < * -Have sequence dependency track use of DEFAULT sequences
      6a175779
    • B
      Done: · 2aa39a4c
      Bruce Momjian 提交于
      < * Have sequence dependency track use of DEFAULT sequences,
      <   seqname.nextval?
      > * -Have sequence dependency track use of DEFAULT sequences
      2aa39a4c
  2. 28 9月, 2005 1 次提交
    • B
      Done: · 455f48dd
      Bruce Momjian 提交于
      < * +Add options to pg_config to show the share_dir, sysconfdir,
      <   pkgincludedir, and localedir
      455f48dd
  3. 27 9月, 2005 2 次提交
  4. 26 9月, 2005 2 次提交
    • B
      Done: · 3ff1dc50
      Bruce Momjian 提交于
      < * Allow protocol-level EXECUTE that is actually a fetch to appear
      <   in the logs as a fetch rather than another execute
      3ff1dc50
    • B
      Add: · 88922598
      Bruce Momjian 提交于
      > * Allow protocol-level BIND parameter values to be logged
      > * Allow protocol-level EXECUTE that is actually a fetch to appear
      >   in the logs as a fetch rather than another execute
      88922598
  5. 24 9月, 2005 3 次提交
    • B
      Add: · 86044a9d
      Bruce Momjian 提交于
      > * Simplify dropping roles that have objects in several databases
      86044a9d
    • B
      Add: · 6db56cdf
      Bruce Momjian 提交于
      > 	o Allow PL/PgSQL to support WITH HOLD cursors
      6db56cdf
    • B
      Add: · bf8e5362
      Bruce Momjian 提交于
      >
      > 	o Display IN, INOUT, and OUT parameters in \df+
      >
      > 	  It probably requires psql to output newlines in the proper
      > 	  column, which is already on the TODO list.
      bf8e5362
  6. 23 9月, 2005 5 次提交
    • B
      Add: · e6bae1c3
      Bruce Momjian 提交于
      > * Add function to report the time of the most recent server reload
      e6bae1c3
    • B
      Add: · 6e85717a
      Bruce Momjian 提交于
      > * Add options to pg_config to show the share_dir, sysconfdir,
      >   pkgincludedir, and localedir
      >
      6e85717a
    • B
      Add: · c79671bd
      Bruce Momjian 提交于
      > * Allow CREATE INDEX to take an additional parameter for use with
      >   special index types
      >
      c79671bd
    • B
      Add: · c37ddf37
      Bruce Momjian 提交于
      >
      > 	  Another idea would be to allow actual SELECT queries in a COPY.
      c37ddf37
    • B
      Add: · 62da04f8
      Bruce Momjian 提交于
      >
      > 	o Allow COPY to output from views
      >
      62da04f8
  7. 21 9月, 2005 1 次提交
    • B
      Merge items: · 8d86982a
      Bruce Momjian 提交于
      <   This would be beneficial when there are few distinct values.
      >   This would be beneficial when there are few distinct values.  This is
      >   already used by GROUP BY.
      946d946
      < * Allow DISTINCT to use hashing like GROUP BY
      8d86982a
  8. 20 9月, 2005 4 次提交
    • B
      Fix typo: · a34ec0ab
      Bruce Momjian 提交于
      < * Allow WAL traffic to be steamed to another server for stand-by
      > * Allow WAL traffic to be streamed to another server for stand-by
      a34ec0ab
    • B
      Add: · 7caaf8a0
      Bruce Momjian 提交于
      > * Allow DISTINCT to use hashing like GROUP BY
      7caaf8a0
    • B
      Add: · 32f2cd3f
      Bruce Momjian 提交于
      > * Allow WAL traffic to be steamed to another server for stand-by
      >   replication
      32f2cd3f
    • B
      Remove: · 78b06948
      Bruce Momjian 提交于
      < * Research use of sched_yield() for spinlock acquisition failure
      78b06948
  9. 19 9月, 2005 1 次提交
  10. 17 9月, 2005 4 次提交
    • B
      Add: · 3743f07a
      Bruce Momjian 提交于
      >
      1032a1034
      > * Remove BeOS and QNX-specific code
      3743f07a
    • B
      Add: · e8960fc3
      Bruce Momjian 提交于
      > 	o Fix SELECT INTERVAL '1' MONTH
      e8960fc3
    • B
      Add: · d64084da
      Bruce Momjian 提交于
      <
      > * Update Bonjour to work with newer cross-platform SDK
      d64084da
    • B
      Update wording: · 0296606f
      Bruce Momjian 提交于
      <
      390d388
      <
      453c451
      < 	  removed or have its heap and index files truncated.  One
      > 	  be removed or have its heap and index files truncated.  One
      < * Use a phantom command counter for nested subtransactions to reduce
      <   per-tuple overhead
      0296606f
  11. 16 9月, 2005 1 次提交
    • B
      Add: · 3f558e3d
      Bruce Momjian 提交于
      > 	o Add single-step debugging of PL/PgSQL functions
      3f558e3d
  12. 03 9月, 2005 7 次提交
    • B
      Add idea: · b72fe49b
      Bruce Momjian 提交于
      <   cmin/cmax pair and is stored in local memory.
      >   cmin/cmax pair and is stored in local memory.  Another idea is to
      >   store both cmin and cmax only in local memory.
      b72fe49b
    • B
      Update. · 264cd5f0
      Bruce Momjian 提交于
      < 	  have its heap and index files truncated.  One issue is
      < 	  that no other backend should be able to add to the table
      < 	  at the same time, which is something that is currently
      < 	  allowed.
      > 	  removed or have its heap and index files truncated.  One
      > 	  issue is that no other backend should be able to add to
      > 	  the table at the same time, which is something that is
      > 	  currently allowed.
      264cd5f0
    • B
      Update: · ef6d5b4e
      Bruce Momjian 提交于
      > 	o Allow COPY on a newly-created table to skip WAL logging
      450a452,456
      > 	  On crash recovery, the table involved in the COPY would
      > 	  have its heap and index files truncated.  One issue is
      > 	  that no other backend should be able to add to the table
      > 	  at the same time, which is something that is currently
      > 	  allowed.
      ef6d5b4e
    • B
      Update: · f8ec875c
      Bruce Momjian 提交于
      < 	o Allow COPY into an empty table to skip WAL logging
      > 	o Allow COPY into an new table to skip WAL logging
      f8ec875c
    • B
      Add: · 5bddded6
      Bruce Momjian 提交于
      > * Use UTF8 encoding for NLS messages so all server encodings can
      >   read them properly
      <         o %Add support for Unicode
      <
      < 	  To fix this, the data needs to be converted to/from UTF16/UTF8
      <           so the Win32 wcscoll() can be used, and perhaps other functions
      < 	  like towupper().  However, UTF8 already works with normal
      < 	  locales but provides no ordering or character set classes.
      5bddded6
    • B
      Update wording: · 3bea1a35
      Bruce Momjian 提交于
      <   could only see committed rows from another transaction. However,
      >   could only see rows from another completed transaction. However,
      981c981
      <   proper visibility of the row, for example, for cursors.
      >   proper visibility of the row's cmin, for example, for cursors.
      3bea1a35
    • B
      Add: · da08559e
      Bruce Momjian 提交于
      > 	o Allow COPY into an empty table to skip WAL logging
      da08559e
  13. 02 9月, 2005 2 次提交
    • B
      Add text: · fad7e8ed
      Bruce Momjian 提交于
      * Merge xmin/xmax/cmin/cmax back into three header fields
      
        Before subtransactions, there used to be only three fields needed to
        store these four values. This was possible because only the current
        transaction looks at the cmin/cmax values. If the current transaction
        created and expired the row the fields stored where xmin (same as
        xmax), cmin, cmax, and if the transaction was expiring a row from a
        another transaction, the fields stored were xmin (cmin was not
        needed), xmax, and cmax. Such a system worked because a transaction
        could only see committed rows from another transaction. However,
        subtransactions can see rows from outer transactions, and once the
        subtransaction completes, the outer transaction continues, requiring
        the storage of all four fields. With subtransactions, an outer
        transaction can create a row, a subtransaction expire it, and when the
        subtransaction completes, the outer transaction still has to have
        proper visibility of the row, for example, for cursors.
      
        One possible solution is to create a phantom cid which represents a
        cmin/cmax pair and is stored in local memory.
      fad7e8ed
    • B
      Duplicate: · 55af2a43
      Bruce Momjian 提交于
      < * Maintain a map of recently-expired rows
      <
      <   This allows vacuum to target specific pages for possible free space
      <   without requiring a sequential scan.
      <
      Update entry:
      
      >   One complexity is that index entries still have to be vacuumed, and
      >   doing this without an index scan (by using the heap values to find the
      >   index entry) might be slow and unreliable, especially for user-defined
      >   index functions.
      55af2a43
  14. 31 8月, 2005 1 次提交
    • B
      Add: · bc065066
      Bruce Momjian 提交于
      > * Eventually enable escape_string_warning and standard_conforming_strings
      bc065066
  15. 29 8月, 2005 1 次提交
    • B
      Add: · a78a5308
      Bruce Momjian 提交于
      > * Add function to return the thread safety status of libpq and ecpg
      a78a5308
  16. 27 8月, 2005 3 次提交
    • B
      Add: · a1a19bb8
      Bruce Momjian 提交于
      > * Allow user-defined types to specify a type modifier at table creation
      >   time
      a1a19bb8
    • B
      Update: · 542faa82
      Bruce Momjian 提交于
      >
      >   Another issue is whether underlying table changes should be reflected
      >   in the view, e.g. should SELECT * show additional columns if they
      >   are added after the view is created.
      542faa82
    • B
      Add: · f9244df7
      Bruce Momjian 提交于
      > 	o Issue a warning if a change-on-restart-only postgresql.conf value
      > 	  is modified  and the server config files are reloaded
      > 	o Mark change-on-restart-only values in postgresql.conf
      205a209
      > 	o Fix SELECT '0.01 years'::interval, '0.01 months'::interval
      f9244df7