1. 27 Oct, 2005 3 commits
    • Bruce Momjian's avatar
      Update: · bc93b374
      Bruce Momjian authored
      < 	o Allow ALTER TABLE RENAME CONSTRAINT
      > 	o Add ALTER TABLE RENAME CONSTRAINT, update index name also
      bc93b374
    • Bruce Momjian's avatar
      Add: · befc607d
      Bruce Momjian authored
      > 	o Have ALTER INDEX update the name of a constraint using that index
      > 	o Allow ALTER TABLE RENAME CONSTRAINT
      befc607d
    • Bruce Momjian's avatar
      Add items from Tom: · 807da29c
      Bruce Momjian authored
      < 	o Add a GUC variable to allow output of interval values in ISO8601
      < 	  format
      212a211,223
      > 	o Add a GUC variable to allow output of interval values in ISO8601
      > 	  format
      > 	o Improve timestamptz subtraction to be DST-aware
      >
      > 	  Currently, subtracting one date from another that crosses a
      > 	  daylight savings time adjustment can return '1 day 1 hour', but
      > 	  adding that back to the first date returns a time one hour in
      > 	  the future.  This is caused by the adjustment of '25 hours' to
      > 	  '1 day 1 hour', and '1 day' is the same time the next day, even
      > 	  if daylight savings adjustments are involved.
      >
      > 	o Fix interval display to support values exceeding 2^31 hours
      > 	o Add overflow checking to timestamp and interval arithmetic
      807da29c
  2. 25 Oct, 2005 1 commit
    • Bruce Momjian's avatar
      Add: · 62cfa0f7
      Bruce Momjian authored
      >
      > 	o Add auto-expanded mode so expanded output is used if the row
      > 	  length is wider than the screen width.
      >
      > 	  Consider using auto-expanded mode for backslash commands like \df+.
      62cfa0f7
  3. 24 Oct, 2005 1 commit
    • Bruce Momjian's avatar
      Add: · 9507b560
      Bruce Momjian authored
      > * Allow user-defined functions retuning a domain value to enforce domain
      >   constraints
      9507b560
  4. 13 Oct, 2005 1 commit
    • Bruce Momjian's avatar
      Update: · 249f07b8
      Bruce Momjian authored
      > * Prevent PQfnumber() from lowercasing unquoted the column name
      >
      >   PQfnumber() should never have been doing lowercasing, but historically
      >   it has so we need a way to prevent it
      >
      249f07b8
  5. 12 Oct, 2005 7 commits
    • Bruce Momjian's avatar
      Remove item: · adc58f14
      Bruce Momjian authored
      < * Prevent libpq's PQfnumber() from lowercasing the column name
      <
      <   One idea is to lowercase all identifiers except those that are
      <   surrounded by quotes.
      <
      adc58f14
    • Bruce Momjian's avatar
      No longer needed: · 0a28eb46
      Bruce Momjian authored
      <
      < * Add code to detect an SMP machine and handle spinlocks accordingly
      <   from distributted.net, http://www1.distributed.net/source,
      <   in client/common/cpucheck.cpp
      <
      <   On SMP machines, it is possible that locks might be released shortly,
      <   while on non-SMP machines, the backend should sleep so the process
      <   holding the lock can complete and release it.
      0a28eb46
    • Bruce Momjian's avatar
      Rearrange: · 4aebb5ad
      Bruce Momjian authored
      < 	o %Add dumping of comments on composite type columns
      < 	o %Add dumping of comments on index columns
      < 	o Stop dumping CASCADE on DROP TYPE commands in clean mode
      > 	o %Add dumping of comments on index columns and composite type columns
      604a603
      > 	o Stop dumping CASCADE on DROP TYPE commands in clean mode
      4aebb5ad
    • Bruce Momjian's avatar
      Done: · d5310ca9
      Bruce Momjian authored
      < 	o %Replace crude DELETE FROM method of pg_dumpall --clean for
      <           cleaning of roles with separate DROP commands
      608a607
      >
      d5310ca9
    • Bruce Momjian's avatar
      Add: · 87a67d18
      Bruce Momjian authored
      <
      > 	o Allow pg_dump --clean to drop roles that own objects or have
      > 	  privileges
      87a67d18
    • Bruce Momjian's avatar
      Add description: · 75229020
      Bruce Momjian authored
      < * Prevent libpq's PQfnumber() from lowercasing the column name?
      > * Prevent libpq's PQfnumber() from lowercasing the column name
      >
      >   One idea is to lowercase all identifiers except those that are
      >   surrounded by quotes.
      >
      75229020
    • Bruce Momjian's avatar
      Add: · 368f0b28
      Bruce Momjian authored
      > 	o Add options like pg_restore -l and -L to pg_dump
      368f0b28
  6. 11 Oct, 2005 1 commit
    • Bruce Momjian's avatar
      Add: · e4aa5be9
      Bruce Momjian authored
      > 	o Allow selection of individual object(s) of all types, not just
      > 	  tables
      > 	o In a selective dump, allow dumping of an object and all its
      > 	  dependencies
      e4aa5be9
  7. 07 Oct, 2005 2 commits
    • Bruce Momjian's avatar
      Update: · ab13353d
      Bruce Momjian authored
      < * Consider compressing indexes by storing key prefix values shared by
      > * Consider compressing indexes by storing key values duplicated in
      735a736,737
      >
      >   This is difficult because it requires datatype-specific knowledge.
      ab13353d
    • Bruce Momjian's avatar
      Add: · 02eb6ea9
      Bruce Momjian authored
      <
      > * Consider compressing indexes by storing key prefix values shared by
      >   several rows as a single index entry
      02eb6ea9
  8. 03 Oct, 2005 2 commits
  9. 27 Sep, 2005 3 commits
  10. 26 Sep, 2005 2 commits
    • Bruce Momjian's avatar
      Done: · 3ff1dc50
      Bruce Momjian authored
      < * Allow protocol-level EXECUTE that is actually a fetch to appear
      <   in the logs as a fetch rather than another execute
      3ff1dc50
    • Bruce Momjian's avatar
      Add: · 88922598
      Bruce Momjian authored
      > * 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
  11. 23 Sep, 2005 5 commits
    • Bruce Momjian's avatar
      Add: · 86044a9d
      Bruce Momjian authored
      > * Simplify dropping roles that have objects in several databases
      86044a9d
    • Bruce Momjian's avatar
      Add: · 6db56cdf
      Bruce Momjian authored
      > 	o Allow PL/PgSQL to support WITH HOLD cursors
      6db56cdf
    • Bruce Momjian's avatar
      Add: · bf8e5362
      Bruce Momjian authored
      >
      > 	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
    • Bruce Momjian's avatar
      Add: · e6bae1c3
      Bruce Momjian authored
      > * Add function to report the time of the most recent server reload
      e6bae1c3
    • Bruce Momjian's avatar
      Add: · 6e85717a
      Bruce Momjian authored
      > * Add options to pg_config to show the share_dir, sysconfdir,
      >   pkgincludedir, and localedir
      >
      6e85717a
  12. 22 Sep, 2005 3 commits
    • Bruce Momjian's avatar
      Add: · c79671bd
      Bruce Momjian authored
      > * Allow CREATE INDEX to take an additional parameter for use with
      >   special index types
      >
      c79671bd
    • Bruce Momjian's avatar
      Add: · c37ddf37
      Bruce Momjian authored
      >
      > 	  Another idea would be to allow actual SELECT queries in a COPY.
      c37ddf37
    • Bruce Momjian's avatar
      Add: · 62da04f8
      Bruce Momjian authored
      >
      > 	o Allow COPY to output from views
      >
      62da04f8
  13. 20 Sep, 2005 4 commits
    • Bruce Momjian's avatar
      Merge items: · 8d86982a
      Bruce Momjian authored
      <   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
    • Bruce Momjian's avatar
      Fix typo: · a34ec0ab
      Bruce Momjian authored
      < * 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
    • Bruce Momjian's avatar
      Add: · 7caaf8a0
      Bruce Momjian authored
      > * Allow DISTINCT to use hashing like GROUP BY
      7caaf8a0
    • Bruce Momjian's avatar
      Add: · 32f2cd3f
      Bruce Momjian authored
      > * Allow WAL traffic to be steamed to another server for stand-by
      >   replication
      32f2cd3f
  14. 19 Sep, 2005 2 commits
  15. 17 Sep, 2005 1 commit
    • Bruce Momjian's avatar
      Add: · 3743f07a
      Bruce Momjian authored
      >
      1032a1034
      > * Remove BeOS and QNX-specific code
      3743f07a
  16. 16 Sep, 2005 2 commits
    • Bruce Momjian's avatar
      Add: · e8960fc3
      Bruce Momjian authored
      > 	o Fix SELECT INTERVAL '1' MONTH
      e8960fc3
    • Bruce Momjian's avatar
      Add: · d64084da
      Bruce Momjian authored
      <
      > * Update Bonjour to work with newer cross-platform SDK
      d64084da