1. 03 3月, 2006 3 次提交
  2. 01 3月, 2006 1 次提交
    • B
      Add: · c6b6f7ad
      Bruce Momjian 提交于
      * Split out libpq pgpass and environment documentation sections to make
        it easier for non-developers to find
      c6b6f7ad
  3. 27 2月, 2006 1 次提交
    • B
      Done: · 52d010d8
      Bruce Momjian 提交于
      > * -Add 'tid != tid ' operator for use in corruption recovery
      52d010d8
  4. 26 2月, 2006 2 次提交
    • N
      TODO updates: · f33d3bc0
      Neil Conway 提交于
      - "Add ON COMMIT capability to CREATE TABLE AS ... SELECT" is done
      
      - "Allow PREPARE to automatically determine parameter types" is done
      
      - "Clean up compiler warnings (especially with gcc version 4)" is done:
        AFAIK there are no remaining gcc4 compiler warnings to be fixed.
      
      - Creating rules to do view updates is *not* an easy TODO item
      f33d3bc0
    • B
      Add intervals: · 305c82e6
      Bruce Momjian 提交于
      > 	o Allow infinite dates and intervals just like infinite timestamps
      305c82e6
  5. 25 2月, 2006 1 次提交
  6. 13 2月, 2006 2 次提交
    • B
      Add: · 589b67d3
      Bruce Momjian 提交于
      >
      > 	o Allow pg_hba.conf to specify host names along with IP addresses
      >
      > 	  Host name lookup could occur when the postmaster reads the
      > 	  pg_hba.conf file, or when the backend starts.  Another
      > 	  solution would be to reverse lookup the connection IP and
      > 	  check that hostname against the host names in pg_hba.conf.
      > 	  We could also then check that the host name maps to the IP
      > 	  address.
      589b67d3
    • B
      Not done: · 3694e706
      Bruce Momjian 提交于
      > 	o %Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME
      3694e706
  7. 12 2月, 2006 5 次提交
    • B
      Done: · 20b50830
      Bruce Momjian 提交于
      > * -Add COMMENT ON for all cluster global objects (roles, databases
      20b50830
    • B
      Done: · 136c3b87
      Bruce Momjian 提交于
      > * -Allow to_char() to print localized month names
      136c3b87
    • B
      Done: · 3884ede6
      Bruce Momjian 提交于
      > * -Add system view to show free space map contents
      3884ede6
    • B
      Done: · 3fcb38f0
      Bruce Momjian 提交于
      > 	o -Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME
      3fcb38f0
    • B
      Done: · 97d37b7a
      Bruce Momjian 提交于
      < 	o Improve psql's handling of multi-line statements
      > 	o -Improve psql's handling of multi-line statements
      97d37b7a
  8. 11 2月, 2006 1 次提交
    • B
      Done: · 642c8cc4
      Bruce Momjian 提交于
      > * -Allow INET + INT8 to increment the host part of the address or
      642c8cc4
  9. 10 2月, 2006 1 次提交
    • B
      Done: · af03b689
      Bruce Momjian 提交于
      < 	o Allow multi-line column values to align in the proper columns
      > 	o -Allow multi-line column values to align in the proper columns
      af03b689
  10. 07 2月, 2006 2 次提交
    • B
      Remove question mark: · 15be0b8c
      Bruce Momjian 提交于
      < * %Disallow changing default expression of a SERIAL column?
      > * %Disallow changing default expression of a SERIAL column
      15be0b8c
    • B
      Split up wal-logging items: · 04a942e3
      Bruce Momjian 提交于
      < * Allow control over which tables are WAL-logged [walcontrol]
      > * Allow WAL logging to be turned off for a table, but the table
      >   might be dropped or truncated during crash recovery [walcontrol]
      <   commit.  To do this, only a single writer can modify the table, and
      <   writes must happen only on new pages.  Readers can continue accessing
      <   the table.  This would affect COPY, and perhaps INSERT/UPDATE too.
      <   Another option is to avoid transaction logging entirely and truncate
      <   or drop the table on crash recovery.  These should be implemented
      <   using ALTER TABLE, e.g. ALTER TABLE PERSISTENCE [ DROP | TRUNCATE |
      <   STABLE | DEFAULT ].  Tables using non-default logging should not use
      <   referential integrity with default-logging tables, and tables using
      <   stable logging probably can not have indexes.  One complexity is
      <   the handling of indexes on TOAST tables.
      >   commit.  This should be implemented using ALTER TABLE, e.g. ALTER
      >   TABLE PERSISTENCE [ DROP | TRUNCATE | DEFAULT ].  Tables using
      >   non-default logging should not use referential integrity with
      >   default-logging tables.  A table without dirty buffers during a
      >   crash could perhaps avoid the drop/truncate.
      >
      > * Allow WAL logging to be turned off for a table, but the table would
      >   avoid being truncated/dropped [walcontrol]
      >
      >   To do this, only a single writer can modify the table, and writes
      >   must happen only on new pages so the new pages can be removed during
      >   crash recovery.  Readers can continue accessing the table.  Such
      >   tables probably cannot have indexes.  One complexity is the handling
      >   of indexes on TOAST tables.
      04a942e3
  11. 04 2月, 2006 2 次提交
  12. 02 2月, 2006 1 次提交
    • B
      Add: · bd5d12a1
      Bruce Momjian 提交于
      > * Allow statistics collector information to be pulled from the collector
      >   process directly, rather than requiring the collector to write a
      >   filesystem file twice a second?
      bd5d12a1
  13. 01 2月, 2006 2 次提交
    • B
      Move items: · c6ef3264
      Bruce Momjian 提交于
      > * Add SQL99 WITH clause to SELECT
      > * Add SQL99 WITH RECURSIVE to SELECT
      < * Add SQL99 WITH clause to SELECT
      < * Add SQL99 WITH RECURSIVE to SELECT
      c6ef3264
    • B
      Add: · 5eb29fea
      Bruce Momjian 提交于
      >
      > 	o Prevent tab completion of SET TRANSACTION from querying the
      > 	  database and therefore preventing the transaction isolation
      > 	  level from being set.
      >
      > 	  Currently, SET <tab> causes a database lookup to check all
      > 	  supported session variables.  This query causes problems
      > 	  because setting the transaction isolation level must be the
      > 	  first statement of a transaction.
      5eb29fea
  14. 26 1月, 2006 1 次提交
    • B
      Done: · 31253219
      Bruce Momjian 提交于
      < * %Prevent INET cast to CIDR if the unmasked bits are not zero, or
      <   zero the bits
      < * %Prevent INET cast to CIDR from dropping netmask, SELECT '1.1.1.1'::inet::cidr
      > * -Zero umasked bits in conversion from INET cast to CIDR
      > * -Prevent INET cast to CIDR from dropping netmask, SELECT '1.1.1.1'::inet::cidr
      31253219
  15. 23 1月, 2006 1 次提交
    • B
      Done: · 1bdc5ab2
      Bruce Momjian 提交于
      < 	o Allow an alias to be provided for the target table in
      < 	  UPDATE/DELETE
      <
      < 	  This is not SQL-spec but many DBMSs allow it.
      <
      > 	o -Allow an alias to be provided for the target table in
      > 	  UPDATE/DELETE (Neil)
      1bdc5ab2
  16. 18 1月, 2006 1 次提交
    • B
      Done: · e1af35af
      Bruce Momjian 提交于
      > 	o -Allow pooled connections to list all open WITH HOLD cursors
      e1af35af
  17. 12 1月, 2006 1 次提交
    • B
      Done: · 9545d66a
      Bruce Momjian 提交于
      > * -Add sleep() function, remove from regress.c
      9545d66a
  18. 10 1月, 2006 1 次提交
    • B
      Done: · 42ff6a04
      Bruce Momjian 提交于
      < * %Allow pooled connections to list all prepared statements
      > * -%Allow pooled connections to list all prepared statements
      42ff6a04
  19. 06 1月, 2006 5 次提交
    • B
      Add: · 6d41b144
      Bruce Momjian 提交于
      >
      > 	* Allow SERIAL sequences to inherit permissions from the base table?
      6d41b144
    • B
      Update: · db6cb1a9
      Bruce Momjian 提交于
      <   stable logging probably can not have indexes.  [wallog]
      >   stable logging probably can not have indexes.  [walcontrol]
      db6cb1a9
    • B
      Update wording: · ac9e14d0
      Bruce Momjian 提交于
      <   STABLE | DEFAULT ].  [wallog]
      >   STABLE | DEFAULT ].  Tables using non-default logging should not use
      >   referential integrity with default-logging tables, and tables using
      >   stable logging probably can not have indexes.  [wallog]
      ac9e14d0
    • B
      Update wording: · e7893db5
      Bruce Momjian 提交于
      <   the table. Another option is to avoid transaction logging entirely
      <   and truncate or drop the table on crash recovery.  These should be
      <   implemented using ALTER TABLE, e.g. ALTER TABLE PERSISTENCE [ DROP |
      <   TRUNCATE | STABLE | DEFAULT ].  [wallog]
      >   the table.  This would affect COPY, and perhaps INSERT/UPDATE too.
      >   Another option is to avoid transaction logging entirely and truncate
      >   or drop the table on crash recovery.  These should be implemented
      >   using ALTER TABLE, e.g. ALTER TABLE PERSISTENCE [ DROP | TRUNCATE |
      >   STABLE | DEFAULT ].  [wallog]
      e7893db5
    • B
      Add: · 1b736817
      Bruce Momjian 提交于
      >
      > * Allow control over which tables are WAL-logged
      >
      >   Allow tables to bypass WAL writes and just fsync() dirty pages on
      >   commit.  To do this, only a single writer can modify the table, and
      >   writes must happen only on new pages.  Readers can continue accessing
      >   the table. Another option is to avoid transaction logging entirely
      >   and truncate or drop the table on crash recovery.  These should be
      >   implemented using ALTER TABLE, e.g. ALTER TABLE PERSISTENCE [ DROP |
      >   TRUNCATE | STABLE | DEFAULT ].  [wallog]
      1b736817
  20. 05 1月, 2006 2 次提交
    • B
      Update item: · 3002492f
      Bruce Momjian 提交于
      < * %Remove behavior of postmaster -o after making postmaster/postgres
      <   flags unique
      > * %Remove behavior of postmaster -o
      3002492f
    • B
      Done: · 9be5beb9
      Bruce Momjian 提交于
      > * -Remove BeOS and QNX-specific code
      9be5beb9
  21. 30 12月, 2005 2 次提交
    • B
      Add: · 7211ff7d
      Bruce Momjian 提交于
      > * Make CLUSTER preserve recently-dead tuples per MVCC requirements
      7211ff7d
    • B
      Update: · e135d963
      Bruce Momjian 提交于
      < * Add missing rtree optimizer selectivity
      > * Improve selectivity functions for geometric operators
      e135d963
  22. 28 12月, 2005 2 次提交
    • B
      Update: · 6fa33572
      Bruce Momjian 提交于
      < * Add missing optimizer selectivities for date, r-tree, etc
      > * Add missing rtree optimizer selectivity
      6fa33572
    • B
      Done: · 1b184c99
      Bruce Momjian 提交于
      < * %Make row-wise comparisons work per SQL spec
      > * -Make row-wise comparisons work per SQL spec
      1b184c99