1. 14 Jun, 2005 2 commits
    • Bruce Momjian's avatar
      Done: · dac94e34
      Bruce Momjian authored
      > 	o -Allow PL/PgSQL's RAISE function to take expressions
      dac94e34
    • Bruce Momjian's avatar
      Done: · 189f89cb
      Bruce Momjian authored
      > * -Use index to restrict rows returned by multi-key index when used with
      189f89cb
  2. 09 Jun, 2005 1 commit
    • Bruce Momjian's avatar
      Remove idea of schema tablespaces: · c51815af
      Bruce Momjian authored
      < 	o Allow databases and schemas to be moved to different tablespaces
      <
      < 	  One complexity is whether moving a schema should move all existing
      < 	  schema objects or just define the location for future object creation.
      <
      > 	o Allow databases to be moved to different tablespaces
      484c480
      < 	  schema. Global system tables can never be moved.
      > 	  tablespace. Global system tables can never be moved.
      c51815af
  3. 07 Jun, 2005 2 commits
    • Bruce Momjian's avatar
      Fix word wrap: · b3e798d7
      Bruce Momjian authored
      <   changes made by the interface driver for its internal use.  One idea is
      <   for this to be a protocol-only feature.  Another approach is to notify
      <   the protocol when a RESET CONNECTION command is used.
      >   changes made by the interface driver for its internal use.  One idea
      >   is for this to be a protocol-only feature.  Another approach is to
      >   notify the protocol when a RESET CONNECTION command is used.
      b3e798d7
    • Bruce Momjian's avatar
      Update text for RESET CONNECTION: · 0f011f6d
      Bruce Momjian authored
      <   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.
      >   temporary tables, removing any NOTIFYs, cursors, open transactions,
      >   prepared queries, currval()s, etc.  This could be used  for connection
      >   pooling.  We could also change RESET ALL to have this functionality.
      >   The difficult of this features is allowing RESET ALL to not affect
      >   changes made by the interface driver for its internal use.  One idea is
      >   for this to be a protocol-only feature.  Another approach is to notify
      >   the protocol when a RESET CONNECTION command is used.
      0f011f6d
  4. 06 Jun, 2005 1 commit
    • Bruce Momjian's avatar
      Add: · 58592150
      Bruce Momjian authored
      > * Fix incorrect rtree results due to wrong assumptions about "over"
      >   operator semantics [rtree]
      58592150
  5. 05 Jun, 2005 4 commits
    • Bruce Momjian's avatar
      Add description for backend termination: · 22dbd540
      Bruce Momjian authored
      <   cleaned up properly.  A new signal is needed for safe termination.
      >   cleaned up properly.  A new signal is needed for safe termination
      >   because backends must first do a query cancel, then exit once they
      >   have run the query cancel cleanup routine.
      22dbd540
    • Bruce Momjian's avatar
      Add TODO.detail for 2phase commit: · ec480a52
      Bruce Momjian authored
      > * Add two-phase commit [2phase]
      ec480a52
    • Bruce Momjian's avatar
      Add TODO.detail. · efe0d080
      Bruce Momjian authored
      <   logs
      >   logs [pitr]
      130c130
      < * Allow a warm standby system to also allow read-only queries
      > * Allow a warm standby system to also allow read-only queries [pitr]
      efe0d080
    • Bruce Momjian's avatar
      Add TODO.detail for timezone: · 3a272cf0
      Bruce Momjian authored
      <   information, either zone name or offset from UTC
      >   information, either zone name or offset from UTC [timezone]
      3a272cf0
  6. 04 Jun, 2005 4 commits
    • Bruce Momjian's avatar
      Add TODO.detail: · 581a8c9f
      Bruce Momjian authored
      > * Allow major upgrades without dump/reload, perhaps using pg_upgrade
      >   [pg_upgrade]
      581a8c9f
    • Bruce Momjian's avatar
      Add pg_dump to TODO.detail. · 249880ff
      Bruce Momjian authored
      249880ff
    • Bruce Momjian's avatar
      Add: · 3360bc13
      Bruce Momjian authored
      > * Allow pg_ctl to work properly with configuration files located outside
      >   the PGDATA directory
      >
      >   pg_ctl can not read the pid file because it isn't located in the
      >   config directory but in the PGDATA directory.  The solution is to
      >   allow pg_ctl to read and understand postgresql.conf to find the
      >   data_directory value.
      >
      3360bc13
    • Bruce Momjian's avatar
      Add description: · 487990e1
      Bruce Momjian authored
      >
      >   O_DIRECT doesn't have the same media write guarantees as fsync, so it
      >   is in addition to the fsync method, not in place of it.
      >
      487990e1
  7. 03 Jun, 2005 3 commits
  8. 02 Jun, 2005 1 commit
    • Bruce Momjian's avatar
      Completed: · c196c7ae
      Bruce Momjian authored
      < 	o Allow COPY to understand \x as a hex byte
      > 	o -Allow COPY to understand \x as a hex byte
      c196c7ae
  9. 30 May, 2005 2 commits
    • Bruce Momjian's avatar
      Move to ALTER section: · b215fae8
      Bruce Momjian authored
      < * Prevent child tables from altering constraints like CHECK that were
      <   inherited from the parent table
      470a469,471
      >
      > 	o Prevent child tables from altering constraints like CHECK that were
      > 	  inherited from the parent table
      b215fae8
    • Bruce Momjian's avatar
      Add: · 09439e21
      Bruce Momjian authored
      > * Prevent child tables from altering constraints like CHECK that were
      >   inherited from the parent table
      09439e21
  10. 28 May, 2005 1 commit
    • Bruce Momjian's avatar
      Remove: · 70f32049
      Bruce Momjian authored
      <
      < * Add XML output to pg_dump and COPY
      <
      <   We already allow XML to be stored in the database, and XPath queries
      <   can be used on that data using /contrib/xml2. It also supports XSLT
      <   transformations.
      70f32049
  11. 27 May, 2005 2 commits
    • Bruce Momjian's avatar
      Add: · 42319310
      Bruce Momjian authored
      > * Consider sorting hash buckets so entries can be found using a binary
      >   search, rather than a linear scan
      > * In hash indexes, consider storing the hash value with or instead
      >   of the key itself
      42319310
    • Bruce Momjian's avatar
      Add: · 770156e1
      Bruce Momjian authored
      > * Add the features of packages
      > 	o  Make private objects accessable only to objects in the same schema
      > 	o  Allow current_schema.objname to access current schema objects
      > 	o  Add session variables
      > 	o  Allow nested schemas
      770156e1
  12. 21 May, 2005 3 commits
    • Bruce Momjian's avatar
      INT4 is probably enough: · c61207b0
      Bruce Momjian authored
      < * Allow INET + INT4/INT8 to increment the host part of the address, or
      > * Allow INET + INT4 to increment the host part of the address, or
      c61207b0
    • Bruce Momjian's avatar
      Mention overflow: · 2e9c04ee
      Bruce Momjian authored
      <   throw an error
      >   throw an error on overflow
      2e9c04ee
    • Bruce Momjian's avatar
      Add: · 6dab58a6
      Bruce Momjian authored
      > * Allow INET + INT4/INT8 to increment the host part of the address, or
      >   throw an error
      6dab58a6
  13. 20 May, 2005 1 commit
  14. 17 May, 2005 4 commits
  15. 16 May, 2005 1 commit
  16. 10 May, 2005 4 commits
    • Bruce Momjian's avatar
      Item removed from CVS: · 075ec42c
      Bruce Momjian authored
      < * -Check for unreferenced table files created by transactions that were
      > * Check for unreferenced table files created by transactions that were
      075ec42c
    • Bruce Momjian's avatar
      Add: · 29873379
      Bruce Momjian authored
      > * Fix sgmltools so PDFs can be generated with bookmarks
      29873379
    • Bruce Momjian's avatar
      Add: · b51f8246
      Bruce Momjian authored
      > * Allow postgresql.conf values to be set so they can not be changed by
      >   the user
      b51f8246
    • Bruce Momjian's avatar
      Done: · d3b62275
      Bruce Momjian authored
      < * Add session start time and last statement time to pg_stat_activity
      > * -Add session start time and last statement time to pg_stat_activity
      134c134
      < * Add the client IP address and port to pg_stat_activity
      > * -Add the client IP address and port to pg_stat_activity
      d3b62275
  17. 07 May, 2005 3 commits
    • Bruce Momjian's avatar
      Add description: · 8a9e3291
      Bruce Momjian authored
      <   Currently locale can only be set during initdb.
      >   Currently locale can only be set during initdb.  No global tables have
      >   locale-aware columns.  However, the database template used during
      >   database creation might have locale-aware indexes.  The indexes would
      >   need to be reindexed to match the new locale.
      8a9e3291
    • Bruce Momjian's avatar
      Done: · f65803a2
      Bruce Momjian authored
      > 	o -Allow COPY to optionally include column headings in the first line
      f65803a2
    • Bruce Momjian's avatar
      Add items: · 5894e7e3
      Bruce Momjian authored
      > * Prevent to_char() on interval from returning meaningless values
      >
      >   For example, to_char('1 month', 'mon') is meaningless.  Basically,
      >   most date-related parameters to to_char() are meaningless for
      >   intervals because interval is not anchored to a date.
      >
      > * Allow to_char() on interval values to accumulate the highest unit
      >   requested
      >
      > 	o to_char(INTERVAL '1 hour 5 minutes', 'MI') => 65
      > 	o to_char(INTERVAL '43 hours 20 minutes', 'MI' ) => 2600
      > 	o to_char(INTERVAL '43 hours 20 minutes', 'WK:DD:HR:MI') => 0:1:19:20
      > 	o to_char(INTERVAL '3 years 5 months','MM') => 41
      >
      >   Some special format flag would be required to request such
      >   accumulation.  Such functionality could also be added to EXTRACT.
      >   Prevent accumulation that crosses the month/day boundary because of
      >   the uneven number of days in a month.
      >
      5894e7e3
  18. 02 May, 2005 1 commit
    • Bruce Momjian's avatar
      Completed: · 3de0e72b
      Bruce Momjian authored
      < * Remove unreferenced table files created by transactions that were
      > * -Check for unreferenced table files created by transactions that were
      3de0e72b