1. 22 Feb, 2005 1 commit
    • Bruce Momjian's avatar
      Add: · 64011b4d
      Bruce Momjian authored
      > 	* Add internationalized message strings
      64011b4d
  2. 21 Feb, 2005 3 commits
    • Bruce Momjian's avatar
      Add port mention: · 32362502
      Bruce Momjian authored
      < * Add the client IP address to pg_stat_activity
      > * Add the client IP address and port to pg_stat_activity
      32362502
    • Bruce Momjian's avatar
      Clarify item: · ac1cbc80
      Bruce Momjian authored
      < * Allow server configuration parameters to be remotely modified
      > * Allow pg_hba.conf settings to be controlled via SQL
      >
      >   This would require a new global table that is dumped to flat file for
      >   use by the postmaster.  We do a similar thing for pg_shadow currently.
      >
      ac1cbc80
    • Bruce Momjian's avatar
      Clarify item: · d5b98e4c
      Bruce Momjian authored
      < * Consider use of open/fcntl(O_DIRECT) to minimize OS caching
      > * Consider use of open/fcntl(O_DIRECT) to minimize OS caching,
      >   especially for WAL writes
      d5b98e4c
  3. 15 Feb, 2005 4 commits
    • Bruce Momjian's avatar
      Change wording: · bb8fcd67
      Bruce Momjian authored
      <   The agreed syntax is:
      >   The proposed syntax is:
      bb8fcd67
    • Bruce Momjian's avatar
      Add mention of syntax for GRANT ALL: · 50263789
      Bruce Momjian authored
      >   The agreed syntax is:
      > 	GRANT SELECT ON ALL TABLES IN public TO phpuser;
      > 	GRANT SELECT ON NEW TABLES IN public TO phpuser;
      >
      50263789
    • Bruce Momjian's avatar
      Fix typo: · b39ce1cc
      Bruce Momjian authored
      < 	o Allow COPY FROM ... CVS to interpret newlines and carriage
      > 	o Allow COPY FROM ... CSV to interpret newlines and carriage
      b39ce1cc
    • Bruce Momjian's avatar
      Add: · 43410176
      Bruce Momjian authored
      > * Add xpath_array() to /contrib/xml2 to return results as an array
      43410176
  4. 14 Feb, 2005 2 commits
    • Bruce Momjian's avatar
      Add: · b25bb4fd
      Bruce Momjian authored
      > * Allow the creation of indexes with mixed ascending/descending specifiers
      b25bb4fd
    • Bruce Momjian's avatar
      Add: · f25df821
      Bruce Momjian authored
      > * Make src/port/snprintf.c thread-safe
      f25df821
  5. 13 Feb, 2005 2 commits
    • Bruce Momjian's avatar
      Clarify: · 5e73d436
      Bruce Momjian authored
      < * Add IP address to pg_stat_activity
      > * Add the client IP address to pg_stat_activity
      5e73d436
    • Bruce Momjian's avatar
      Add: · 6370007c
      Bruce Momjian authored
      > * Add IP address to pg_stat_activity
      6370007c
  6. 08 Feb, 2005 2 commits
  7. 02 Feb, 2005 1 commit
    • Bruce Momjian's avatar
      Update RESET ALL items: · 947ae56d
      Bruce Momjian authored
      <   all temporary tables, removal of any NOTIFYs, etc.  This could be used
      <   for connection pooling.  We could also change RESET ALL to have this
      <   functionality.
      >   all temporary tables, removal of any NOTIFYs, cursors, prepared
      >   queries(?), currval()s, etc.  This could be used for connection pooling.
      >   We could also change RESET ALL to have this functionality.
      947ae56d
  8. 01 Feb, 2005 2 commits
    • Bruce Momjian's avatar
      Add FETCH/MOVE: · 68b0e298
      Bruce Momjian authored
      < * Change LIMIT/OFFSET to use int8
      > * Change LIMIT/OFFSET and FETCH/MOVE to use int8
      68b0e298
    • Bruce Momjian's avatar
      Add: · bb14d8be
      Bruce Momjian authored
      > * Allow GRANT/REVOKE permissions to be inherited by objects based on
      >   schema permissions
      bb14d8be
  9. 22 Jan, 2005 1 commit
    • Bruce Momjian's avatar
      Update count(*) discussion ideas: · b60a8512
      Bruce Momjian authored
      <   BY col {DESC} LIMIT 1. Completing this item involves making this
      >   BY col {DESC} LIMIT 1. Completing this item involves doing this
      <   invalidated if anyone modifies the table.
      <
      >   invalidated if anyone modifies the table.  Another idea is to
      >   get a count directly from a unique index, but for this to be
      >   faster than a sequential scan it must avoid access to the heap
      >   to obtain tuple visibility information.
      >
      > * Allow data to be pulled directly from indexes
      >
      >   Currently indexes do not have enough tuple tuple visibility
      >   information to allow data to be pulled from the index without
      >   also accessing the heap.  One way to allow this is to set a bit
      >   to index tuples to indicate if a tuple is currently visible to
      >   all transactions when the first valid heap lookup happens.  This
      >   bit would have to be cleared when a heap tuple is expired.
      >
      b60a8512
  10. 19 Jan, 2005 1 commit
    • Bruce Momjian's avatar
      Add: · 0d19d8b8
      Bruce Momjian authored
      > * Add 'tid != tid ' operator for use in corruption recovery
      0d19d8b8
  11. 04 Jan, 2005 2 commits
    • Bruce Momjian's avatar
      Update wording: · 33a6dcfc
      Bruce Momjian authored
      < * Allow building with directories containing spaces
      > * Allow building in directories containing spaces
      <   There are two capabilities here, first the ability to build from a
      <   source directory that contains spaces, and second the ability to install
      <   into a directory that contains spaces.  The first is probably not
      <   possible because 'gmake' and other compiler tools do not fully support
      <   spaces in path names.  The second is possible with proper quoting in
      <   the makefiles.  Because PostgreSQL supports relocatable installs, it
      <   is possible to install into a directory that doesn't contain spaces and
      <   then copy the install to a directory with spaces.
      >   This is probably not possible because 'gmake' and other compiler tools
      >   do not fully support quoting of paths with spaces.
      >
      > * Allow installing to directories containing spaces
      >
      >   This is possible if proper quoting is added to the makefiles for the
      >   install targets.  Because PostgreSQL supports relocatable installs, it
      >   is already possible to install into a directory that doesn't contain
      >   spaces and then copy the install to a directory with spaces.
      33a6dcfc
    • Bruce Momjian's avatar
      Update item for install with spaces: · 24cab1e8
      Bruce Momjian authored
      >   There are two capabilities here, first the ability to build from a
      >   source directory that contains spaces, and second the ability to install
      >   into a directory that contains spaces.  The first is probably not
      >   possible because 'gmake' and other compiler tools do not fully support
      >   spaces in path names.  The second is possible with proper quoting in
      >   the makefiles.  Because PostgreSQL supports relocatable installs, it
      >   is possible to install into a directory that doesn't contain spaces and
      >   then copy the install to a directory with spaces.
      24cab1e8
  12. 02 Jan, 2005 1 commit
    • Bruce Momjian's avatar
      Add: · 11373311
      Bruce Momjian authored
      > * Allow building with directories containing spaces
      11373311
  13. 01 Jan, 2005 3 commits
    • Bruce Momjian's avatar
      Update: · 3ca924a9
      Bruce Momjian authored
      < 	  the Win32 wcscoll() can be used.
      > 	  the Win32 wcscoll() can be used, and perhaps other functions
      > 	  like towupper().
      3ca924a9
    • Bruce Momjian's avatar
      Update: · bfeaefd2
      Bruce Momjian authored
      < 	  the Win32 strcoll() can be used.
      > 	  the Win32 wcscoll() can be used.
      bfeaefd2
    • Bruce Momjian's avatar
      Update: · f8822476
      Bruce Momjian authored
      <         o Disallow encodings like UTF8 which which PostgreSQL supports
      >         o Disallow encodings like UTF8 which PostgreSQL supports
      914a915,917
      >
      > 	  To fix UTF8, the data needs to be converted to UTF16 and then
      > 	  the Win32 strcoll() can be used.
      f8822476
  14. 27 Dec, 2004 1 commit
    • Bruce Momjian's avatar
      Add: · af71fbaf
      Bruce Momjian authored
      > * Improve the background writer
      >
      >   Allow the background writer to more efficiently write dirty buffers
      >   from the end of the LRU cache and use a clock sweep algorithm to
      >   write other dirty buffers to reduced checkpoint I/O
      af71fbaf
  15. 21 Dec, 2004 2 commits
    • Bruce Momjian's avatar
      Add: · c20d6062
      Bruce Momjian authored
      > *  Allow the PITR process to be debugged and data examined
      c20d6062
    • Bruce Momjian's avatar
      Add: · 7f938227
      Bruce Momjian authored
      > * Allow a warm standby system to also allow read-only queries
      7f938227
  16. 19 Dec, 2004 1 commit
    • Bruce Momjian's avatar
      Add: · cd5c7e7c
      Bruce Momjian authored
      > * Allow psql \pset boolean variables to set to fixed values, rather than toggle
      cd5c7e7c
  17. 17 Dec, 2004 1 commit
    • Bruce Momjian's avatar
      Add Win32: · 24658a2d
      Bruce Momjian authored
      >         o Disallow encodings like UTF8 which which PostgreSQL supports
      >           but the operating system does not (already disallowed by
      > 	  pginstaller)
      24658a2d
  18. 13 Dec, 2004 3 commits
    • Bruce Momjian's avatar
      Remove: · 3ff04182
      Bruce Momjian authored
      < 	o Allow the shared memory address to be configured via GUC
      3ff04182
    • Bruce Momjian's avatar
      Done: · cc4f22c1
      Bruce Momjian authored
      < 	o Remove per-backend parameter file and move into shared memory
      
      Add for Win32:
      > 	o Allow the shared memory address to be configured via GUC
      cc4f22c1
    • Bruce Momjian's avatar
      Add: · e13c5cd3
      Bruce Momjian authored
      >
      > * Allow the size of the buffer cache used by temporary objects to be
      >   specified as a GUC variable
      >
      >   Larger local buffer cache sizes requires more efficient handling of
      >   local cache lookups.
      e13c5cd3
  19. 03 Dec, 2004 2 commits
    • Bruce Momjian's avatar
      Add: · cf52f83a
      Bruce Momjian authored
      > * ANALYZE should record a pg_statistic entry for an all-NULL column
      cf52f83a
    • Bruce Momjian's avatar
      Add: · 28c8c99a
      Bruce Momjian authored
      > * Fix priority ordering of read and write light-weight locks (Neil)
      28c8c99a
  20. 02 Dec, 2004 5 commits
    • Bruce Momjian's avatar
      Add: · 9b711e76
      Bruce Momjian authored
      <
      > 	o Fix problem with shared memory on the Win32 Terminal Server
      9b711e76
    • Bruce Momjian's avatar
      Add for Win32: · 576bf2f7
      Bruce Momjian authored
      > 	o Improve dlerror() reporting string
      576bf2f7
    • Bruce Momjian's avatar
      Add: · be6e9f62
      Bruce Momjian authored
      > * Allow a warm standby system to also allow read-only queries
      >
      >   This is useful for checking PITR recovery.
      >
      be6e9f62
    • Bruce Momjian's avatar
      Add: · bbf29949
      Bruce Momjian authored
      > * Fix psql's display of schema information (Neil)
      bbf29949
    • Bruce Momjian's avatar
      Add: · b383c1db
      Bruce Momjian authored
      >
      > * Allow FOR UPDATE queries to do NOWAIT locks
      >
      b383c1db