1. 21 10月, 2003 1 次提交
    • B
      Update per Tom: · d58c70c6
      Bruce Momjian 提交于
      
      < * Allow INET subnet tests using non-constants
      > * Allow INET subnet tests to use indexes
      101a102
      > 	o Allow MIN()/MAX() on arrays
      144c145
      < * Allow CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops)
      > * -Allow CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops)
      166c167
      < * Improve handling of index scans for NULL
      > * Allow use of indexes to search for NULLs
      203a205
      > * Add optional textual message to NOTIFY
      252c254
      < 	o Add SET SCHEMA
      > 	o Add SET PATH for schemas
      297a300
      > * Allow fastpast to pass values in portable format
      344a348
      > * Allow statement-level triggers to access modified rows
      526d529
      < 	o Add optional textual message to NOTIFY
      530d532
      < 	o Allow fastpast to pass values in portable format
      533c535
      < 	o Special passing of binary values in platform-neutral format (bytea?)
      > 	o -Special passing of binary values in platform-neutral format (bytea?)
      d58c70c6
  2. 16 10月, 2003 1 次提交
    • B
      Add: · a9c1ff66
      Bruce Momjian 提交于
      > * Allow pg_dump to dump CREATE CONVERSION (Christopher)
      a9c1ff66
  3. 10 10月, 2003 4 次提交
    • B
      Add: · d11998f3
      Bruce Momjian 提交于
      > * Prevent libpq's PQfnumber() from lowercasing the column name
      572d572
      < * Vadim is Vadim B. Mikheev <vadim4o@email.com> of Sector Data
      d11998f3
    • B
      Add TODO.detail for count(*): · 20982a71
      Bruce Momjian 提交于
      >   to allow fast COUNT(*) queries with no WHERE clause(?) [count]
      20982a71
    • B
      Add: · de8b3b49
      Bruce Momjian 提交于
      > 	o Allow PL/pgSQL to handle %TYPE arrays, e.g. tab.col%TYPE[]
      de8b3b49
    • B
      Add: · d8581fbb
      Bruce Momjian 提交于
      > * Have VACUUM FULL use REINDEX rather than index vacuum
      d8581fbb
  4. 09 10月, 2003 5 次提交
    • B
      Update: · b510c442
      Bruce Momjian 提交于
      > * COMMENT ON [ CAST | CONVERSION | OPERATOR CLASS | LARGE OBJECT | LANGUAGE ]
      >   (Christopher)
      b510c442
    • B
      Add: · c1a0d72d
      Bruce Momjian 提交于
      > * COMMENT ON [ CAST | CONVERSION | OPERATOR CLASS | LARGE OBJECT ] (Christopher)
      c1a0d72d
    • B
      Add: · 67afe3d8
      Bruce Momjian 提交于
      <
      346a346
      > * Remove CREATE CONSTRAINT TRIGGER
      67afe3d8
    • B
      Add 2-phase info, add Win32 URL: · 5fc9d0e3
      Bruce Momjian 提交于
      < 	o Sample implementation in contrib/rserv
      29c28,29
      < * Create native Win32 port [win32]
      > * Create native Win32 port, http://momjian.postgresql.org/main/writings/pgsql/win32.html
      >
      367c367,368
      < * Two-phase commit to implement distributed transactions
      > * Add two-phase commit to all distributed transactions with
      >   offline/readonly server status or administrator notification for failure
      5fc9d0e3
    • B
      Add: · d5ea0d5e
      Bruce Momjian 提交于
      > * Use background process to write dirty shared buffers to disk
      d5ea0d5e
  5. 05 10月, 2003 1 次提交
    • B
      Modify: · ec1fbbb5
      Bruce Momjian 提交于
      < * Consider using MVCC to cache count(*) queries with no WHERE clause
      > * Use a fixed row count and a +/- count with MVCC visibility rules
      >   to allow fast COUNT(*) queries with no WHERE clause(?)
      ec1fbbb5
  6. 30 9月, 2003 3 次提交
    • B
      Remove, already done: · 7bc0678e
      Bruce Momjian 提交于
      < 	o Fixed PL/Tcl's spi_prepare to accept full qualified type names in
      < 	  the parameter type list
      7bc0678e
    • B
      Add: · fb72fc8b
      Bruce Momjian 提交于
      > 	o Fixed PL/Tcl's spi_prepare to accept full qualified type names in
      > 	  the parameter type list
      fb72fc8b
    • B
      Add: · e7a9ba48
      Bruce Momjian 提交于
      > * Have SHOW ALL and pg_settings show descriptions for server-side variables(Joe)
      e7a9ba48
  7. 24 9月, 2003 2 次提交
    • B
      Add: · 45de72b6
      Bruce Momjian 提交于
      > * Allow LISTEN/NOTIFY to store info in memory rather than tables
      45de72b6
    • B
      Add: · eed6ff45
      Bruce Momjian 提交于
      * Allow major upgrades without dump/reload, perhaps using pg_upgrade
      eed6ff45
  8. 11 9月, 2003 2 次提交
    • B
      Add: · 2b56a964
      Bruce Momjian 提交于
      > * Issue NOTICE if foreign key data type doesn't match primary key
      2b56a964
    • B
      Add: · e303be78
      Bruce Momjian 提交于
      > * Have EXPLAIN ANALYZE highlight poor optimizer estimates
      e303be78
  9. 10 9月, 2003 1 次提交
    • B
      Add: · 22b305ad
      Bruce Momjian 提交于
      > * Have pg_dump -c clear the database using dependency information
      22b305ad
  10. 09 9月, 2003 1 次提交
    • B
      Add: · e54965c0
      Bruce Momjian 提交于
             o Allow ALTER TABLE to change constraint deferrability and actions
      e54965c0
  11. 06 9月, 2003 1 次提交
    • B
      Done: · 23d07fa3
      Bruce Momjian 提交于
      < * Allow psql to do table completion for SELECT * FROM schema_part and
      > * -Allow psql to do table completion for SELECT * FROM schema_part and
      23d07fa3
  12. 05 9月, 2003 4 次提交
    • B
      Add: · 5b49f902
      Bruce Momjian 提交于
      > * Maintain a map of recently-expired of pages so vacuum can reclaim
      >   free space without a sequential scan
      5b49f902
    • B
      Update as done: · 248af40d
      Bruce Momjian 提交于
      > * -Improve concurrency of hash indexes (Tom)
      248af40d
    • B
      Add: · 8ac3510a
      Bruce Momjian 提交于
      > 	o Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME
      8ac3510a
    • B
      Add: · 8af31863
      Bruce Momjian 提交于
      <
      > * Print table names with constraint names in error messages, or make constraint
      >   names unique within a schema
      8af31863
  13. 04 9月, 2003 2 次提交
    • B
      Add: · adb13f23
      Bruce Momjian 提交于
      > * Allow to_char to print localized month names (Karel)
      adb13f23
    • B
      Done: · 4e85f760
      Bruce Momjian 提交于
      * -Have standalone backend read postgresql.conf (Tom)
      4e85f760
  14. 25 8月, 2003 2 次提交
    • B
      Add: · 048cb1ce
      Bruce Momjian 提交于
      > * Add a libpq function to support Parse/DescribeStatement capability
      048cb1ce
    • B
      Add: · 55b5fc9a
      Bruce Momjian 提交于
      	* Allow TRUNCATE ... CASCADE/RESTRICT
      55b5fc9a
  15. 18 8月, 2003 1 次提交
    • B
      Done: · 14149035
      Bruce Momjian 提交于
      > * -Add btree index support for reltime, tinterval, regproc (Tom)
      14149035
  16. 17 8月, 2003 7 次提交
    • B
      Add: · 42588d43
      Bruce Momjian 提交于
      > * Allow PREPARE of cursors
      42588d43
    • B
      Add: · 7f5079db
      Bruce Momjian 提交于
      > * Fix upper()/lower() to work for multibyte encodings
      >
      7f5079db
    • B
      Add: · b433f405
      Bruce Momjian 提交于
      > * Allow pooled connections to query prepared queries
      > * Allow pooled connections to close all open WITH HOLD cursors
      b433f405
    • B
      Add: · 6499ebb7
      Bruce Momjian 提交于
      > * Add ALTER DOMAIN, AGGREGATE, CONVERSION, SEQUENCE ... OWNER TO
      >
      6499ebb7
    • B
      Add: · 237b4d68
      Bruce Momjian 提交于
      > * Add TRUNCATE ... CASCADE
      237b4d68
    • B
      Add: · 01d0d346
      Bruce Momjian 提交于
      > * Add pg_get_acldef(), pg_get_typedefault(), and pg_get_attrdef()
      01d0d346
    • B
      Add mention that Kerberos 4 isn't recommended. · 226bae27
      Bruce Momjian 提交于
      226bae27
  17. 13 8月, 2003 1 次提交
    • B
      I'm quite fond of doing VPATH builds, i.e. building outside the source · c090b053
      Bruce Momjian 提交于
      tree. This also catches lots of little Makefile bugs, so here's a small
      patch for one of them (replacing an explicit reference to thread.c with
      a reference to it as the first prerequsite of the rule makes make look
      for it in the place where it was found (the source tree) rather than in
      the build tree. (using GNU make 3.79.1)
      
      John Gray
      c090b053
  18. 12 8月, 2003 1 次提交
    • B
      Add: · 730b3a15
      Bruce Momjian 提交于
      > * Prevent unneeded quoting in psql \d output using fmtId()
      730b3a15