1. 31 7月, 2005 1 次提交
  2. 30 7月, 2005 9 次提交
    • B
      Add constraint exclusion items: · 90524998
      Bruce Momjian 提交于
      <
      > * Allow EXPLAIN to identify tables that were skipped because of
      >   enable_constraint_exclusion
      > * Allow EXPLAIN output to be more easily processed by scripts
      760a763
      > * Allow enable_constraint_exclusion to work for UPDATE and DELETE queries
      90524998
    • B
      Add: · 32681629
      Bruce Momjian 提交于
      <
      > * Allow enable_constraint_exclusion to work for UNIONs like it does for
      >   inheritance
      32681629
    • B
      Add: · f9512130
      Bruce Momjian 提交于
      > * Prevent inherited tables from expanding temporary subtables of other
      >   sessions
      f9512130
    • B
      Add: · aa8290be
      Bruce Momjian 提交于
      > * Add system view to show free space map contents
      884c885
      < 	o Move into the backend code
      > 	o -Move into the backend code
      aa8290be
    • B
      Add: · 24df49bd
      Bruce Momjian 提交于
      > * Allow SELECT ... FOR UPDATE on inherited tables
      24df49bd
    • B
      Clarify: · 43e33c51
      Bruce Momjian 提交于
      < * Add TRUNCATE permission
      > * Add a separate TRUNCATE permission
      43e33c51
    • B
      Add: · 3fae29ef
      Bruce Momjian 提交于
      > * Add TRUNCATE permission
      >
      >   Currently only the owner can TRUNCATE a table because triggers are not
      >   called, and the table is locked in exclusive mode.
      >
      3fae29ef
    • B
      Add: · 9ebe05c5
      Bruce Momjian 提交于
      > * Add PQescapeIdentifier() to libpq
      9ebe05c5
    • B
      Add detail: · f387e061
      Bruce Momjian 提交于
      >
      > 	   If CRC check fails during recovery, remember the page in case
      > 	   a later CRC for that page properly matches.
      >
      f387e061
  3. 29 7月, 2005 1 次提交
    • B
      Done: · 5b63e7b4
      Bruce Momjian 提交于
      < * Consider use of open/fcntl(O_DIRECT) to minimize OS caching,
      <   especially for WAL writes
      > * -Consider use of open/fcntl(O_DIRECT) to minimize OS caching,
      >   for WAL writes
      5b63e7b4
  4. 25 7月, 2005 1 次提交
    • B
      Add: · 9ad9e694
      Bruce Momjian 提交于
      > 	o Allow postgresql.conf file values to be changed via an SQL API
      > 	o Allow the server to be stopped/restarted via an SQL API
      9ad9e694
  5. 21 7月, 2005 1 次提交
    • B
      Add: · 0e5c62d0
      Bruce Momjian 提交于
      <
      > * Research storing disk pages with no alignment/padding
      0e5c62d0
  6. 10 7月, 2005 1 次提交
    • B
      Update. · 42e7b0f0
      Bruce Momjian 提交于
      < 	  computations should adjust based on the time zone rules, e.g.
      < 	  adding 24 hours to a timestamp would yield a different result from
      < 	  adding one day.
      <
      > 	  computations should adjust based on the time zone rules.
      42e7b0f0
  7. 08 7月, 2005 2 次提交
    • B
      Done: · a4ffa382
      Bruce Momjian 提交于
      > * -Prevent dropping user that still owns objects, or auto-drop the objects
      a4ffa382
    • B
      Update: · 442b59dd
      Bruce Momjian 提交于
      < 	   writer.
      > 	   writer.  It might cause problems for applying WAL on recovery
      > 	   into a partially-written page, but later the full page will be
      > 	   replaced from WAL.
      442b59dd
  8. 07 7月, 2005 1 次提交
    • B
      Update: · f0a2a919
      Bruce Momjian 提交于
      >
      > 	o  -Add ability to turn off full page writes
      > 	o  When off, write CRC to WAL and check file system blocks
      > 	   on recovery
      > 	o  Write full pages during file system write and not when
      > 	   the page is modified in the buffer cache
      >
      > 	   This allows most full page writes to happen in the background
      > 	   writer.
      f0a2a919
  9. 06 7月, 2005 3 次提交
    • B
      Done: · 7d2e1cb7
      Bruce Momjian 提交于
      > * -Add function to return compressed length of TOAST data values
      7d2e1cb7
    • B
      Remove, now have GUC: · d22a3727
      Bruce Momjian 提交于
      < * Turn off full page writes if fsync is disabled
      <
      <   If fsync is off, there is no purpose in writing full pages to WAL
      <
      d22a3727
    • B
      Add: · 3bf4e412
      Bruce Momjian 提交于
      <
      881a881,882
      > 	o Improve xid wraparound detection by recording per-table rather
      > 	  than per-database
      3bf4e412
  10. 05 7月, 2005 2 次提交
  11. 04 7月, 2005 2 次提交
    • B
      Update · e652d2c4
      Bruce Momjian 提交于
      > * Allow GIST indexes to create certain complex index types, like digital
      >   trees (see Aoki)
      >
      783a787
      >
      e652d2c4
    • B
      Update wording: · 3848532c
      Bruce Momjian 提交于
      <   Currently, to protect against partial disk page writes, we write the
      >   Currently, to protect against partial disk page writes, we write
      877c877
      < * Turn off after-change writes if fsync is disabled
      > * Turn off full page writes if fsync is disabled
      3848532c
  12. 02 7月, 2005 4 次提交
    • B
      Update: · 654efe6a
      Bruce Momjian 提交于
      < * Add rtree index support for line, lseg, path, point
      > * Add more gist index support for geometric data types
      654efe6a
    • B
      Clarify: · f009248a
      Bruce Momjian 提交于
      < 	o Replace crude DELETE FROM method of pg_dumpall for cleaning of
      < 	  roles with separate DROP commands
      > 	o Replace crude DELETE FROM method of pg_dumpall --clean for
      >           cleaning of roles with separate DROP commands
      f009248a
    • B
      Update for roles: · fee590c8
      Bruce Momjian 提交于
      < * Allow limits on per-db/user connections
      > * Allow limits on per-db/role connections
      < * Prevent default re-use of sysids for dropped users and roles
      <
      <   Currently, if a user is removed while he still owns objects, a new
      <   user given might be given their user id and inherit the
      <   previous users objects.
      <
      450c444
      < * Add COMMENT ON for all cluster global objects (users, roles, databases
      > * Add COMMENT ON for all cluster global objects (roles, databases
      609c603
      < 	  users and roles with separate DROP commands
      > 	  roles with separate DROP commands
      fee590c8
    • B
      Update for roles: · b00f557d
      Bruce Momjian 提交于
      < * Prevent default re-use of sysids for dropped users and groups
      > * Prevent default re-use of sysids for dropped users and roles
      450c450
      < * Add COMMENT ON for all cluster global objects (users, groups, databases
      > * Add COMMENT ON for all cluster global objects (users, roles, databases
      609c609
      < 	  users and groups with separate DROP commands
      > 	  users and roles with separate DROP commands
      b00f557d
  13. 01 7月, 2005 2 次提交
  14. 28 6月, 2005 1 次提交
    • B
      Done: · 977530d8
      Bruce Momjian 提交于
      > * -Add concurrency to GIST
      977530d8
  15. 27 6月, 2005 2 次提交
    • B
      Done: · fc722403
      Bruce Momjian 提交于
      > * -Remove kerberos4 from source tree
      fc722403
    • B
      Done: · a051da02
      Bruce Momjian 提交于
      > 	o -Allow PL/pgSQL EXECUTE query_var INTO record_var;
      a051da02
  16. 25 6月, 2005 6 次提交
    • B
      Add: · 252600fa
      Bruce Momjian 提交于
      > 	o Pass arrays natively instead of as text between plperl and postgres
      > 	o Add support for polymorphic arguments and return types to plperl
      252600fa
    • B
      Update: · 557a978b
      Bruce Momjian 提交于
      < * Allow per-user, per-group quotas per-tablespace
      > * Allow per-tablespace quotas
      557a978b
    • B
      Update: · d08149d7
      Bruce Momjian 提交于
      < * Allow per-user and per-tablespaces quotas
      > * Allow per-user, per-group quotas per-tablespace
      d08149d7
    • B
      Add: · 886c8a54
      Bruce Momjian 提交于
      > * Allow per-user and per-tablespaces quotas
      886c8a54
    • B
      Add item: · 66911180
      Bruce Momjian 提交于
      > * Add NUMERIC division operator that doesn't round?
      >
      >   Currently NUMERIC _rounds_ the result to the specified precision.
      >   This means division can return a result that multiplied by the
      >   divisor is greater than the dividend, e.g. this returns a value > 10:
      >
      >     SELECT (10::numeric(2,0) / 6::numeric(2,0))::numeric(2,0) * 6;
      >
      >   The positive modulus result returned by NUMERICs might be considered
      >   inaccurate, in one sense.
      >
      66911180
    • B
      Add desciption for terminate: · f3dbacab
      Bruce Momjian 提交于
      >
      >   Currently SIGTERM of a backend can lead to lock table corruption.
      >
      f3dbacab
  17. 24 6月, 2005 1 次提交
    • B
      Done: · 693658a5
      Bruce Momjian 提交于
      > * -Fix incorrect rtree results due to wrong assumptions about "over"
      >   operator semantics
      693658a5