On Mon, Aug 22, 2005 at 07:09:10PM -0400, Bruce Momjian wrote:
> Jim C. Nasby wrote:
> > Can someone turn these items into a "beginning hacker's TODO" as has
> > been discussed before? Or find a way to mark them on the main TODO?
> >
> > If someone wants to tell me how this should be done and give me whatever
> > files need to be changed I'd be happy to submit a patch.
>
> Sure, submit a diff against doc/TODO and mark them with something like
> %.
Here's my stab at marking items. I picked items that I thought would
either be well-contained or that would be pretty straightforward. But
since I'm not very familiar with the code itself a lot of these could be
way off-base. I tried to err on the side of marking things that might be
boarderline since presumably it's easier for someone to see a marked
item and veto it rather than look at the entire list and try and find
new items. In any case, it wouldn't hurt for someone to make another
pass after this is applied and look for easy items that I missed.
BTW, while I was doing this it struck me that it might make sense to
have a difficulty ranking of, say 1-5, instead of just marking beginner
items. Thoughts?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.com 512-569-9461
Index: TODO
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/TODO,v
retrieving revision 1.1626
diff -c -r1.1626 TODO
*** TODO 23 Aug 2005 23:51:16 -0000 1.1626
--- TODO 24 Aug 2005 05:49:50 -0000
***************
*** 19,28 ****
Administration
==============
! * Remove behavior of postmaster -o after making postmaster/postgres
flags unique
* -Allow limits on per-db/role connections
! * Allow pooled connections to list all prepared queries
This would allow an application inheriting a pooled connection to know
the queries prepared in the current session.
--- 19,28 ----
Administration
==============
! * %Remove behavior of postmaster -o after making postmaster/postgres
flags unique
* -Allow limits on per-db/role connections
! * %Allow pooled connections to list all prepared queries
This would allow an application inheriting a pooled connection to know
the queries prepared in the current session.
***************
*** 37,43 ****
Currently SIGTERM of a backend can lead to lock table corruption.
* -Prevent dropping user that still owns objects, or auto-drop the objects
! * Set proper permissions on non-system schemas during db creation
Currently all schemas are owned by the super-user because they are
copied from the template1 database.
--- 37,43 ----
Currently SIGTERM of a backend can lead to lock table corruption.
* -Prevent dropping user that still owns objects, or auto-drop the objects
! * %Set proper permissions on non-system schemas during db creation
Currently all schemas are owned by the super-user because they are
copied from the template1 database.
***************
*** 61,72 ****
* Configuration files
! o Add "include file" functionality in postgresql.conf
o Allow postgresql.conf values to be set so they can not be changed
by the user
o Allow commenting of variables in postgresql.conf to restore them
to defaults
! o Allow pg_hba.conf settings to be controlled via SQL
This would add a function to load the SQL table from
pg_hba.conf, and one to writes its contents to the flat file.
--- 61,72 ----
* Configuration files
! o %Add "include file" functionality in postgresql.conf
o Allow postgresql.conf values to be set so they can not be changed
by the user
o Allow commenting of variables in postgresql.conf to restore them
to defaults
! o %Allow pg_hba.conf settings to be controlled via SQL
This would add a function to load the SQL table from
pg_hba.conf, and one to writes its contents to the flat file.
***************
*** 74,80 ****
can be inserted between existing rows, e.g. row 2.5 goes
between row 2 and row 3.
! o Allow postgresql.conf file values to be changed via an SQL
API, perhaps using SET GLOBAL
o Allow the server to be stopped/restarted via an SQL API
--- 74,80 ----
can be inserted between existing rows, e.g. row 2.5 goes
between row 2 and row 3.
! o %Allow postgresql.conf file values to be changed via an SQL
API, perhaps using SET GLOBAL
o Allow the server to be stopped/restarted via an SQL API
***************
*** 102,108 ****
requires a tool that will call that function and connect to each
database to find the objects in each database for that tablespace.
! o Add a GUC variable to control the tablespace for temporary objects
and sort files
It could start with a random tablespace from a supplied list and
--- 102,108 ----
requires a tool that will call that function and connect to each
database to find the objects in each database for that tablespace.
! o %Add a GUC variable to control the tablespace for temporary objects
and sort files
It could start with a random tablespace from a supplied list and
***************
*** 131,137 ****
the archive contins all the files needed for point-in-time
recovery.
! o Create dump tool for write-ahead logs for use in determining
transaction id for point-in-time recovery
o Allow a warm standby system to also allow read-only queries
[pitr]
--- 131,137 ----
the archive contins all the files needed for point-in-time
recovery.
! o %Create dump tool for write-ahead logs for use in determining
transaction id for point-in-time recovery
o Allow a warm standby system to also allow read-only queries
[pitr]
***************
*** 149,155 ****
This would allow server log information to be easily loaded into
a database for analysis.
! * Add ability to monitor the use of temporary sort files
* -Add session start time and last statement time to pg_stat_activity
* -Add a function that returns the start time of the postmaster
* Allow server logs to be remotely read and removed using SQL commands
--- 149,155 ----
This would allow server log information to be easily loaded into
a database for analysis.
! * %Add ability to monitor the use of temporary sort files
* -Add session start time and last statement time to pg_stat_activity
* -Add a function that returns the start time of the postmaster
* Allow server logs to be remotely read and removed using SQL commands
***************
*** 158,164 ****
Data Types
==========
! * Remove Money type, add money formatting for decimal type
* Change NUMERIC to enforce the maximum precision, and increase it
* Add NUMERIC division operator that doesn't round?
--- 158,164 ----
Data Types
==========
! * %Remove Money type, add money formatting for decimal type
* Change NUMERIC to enforce the maximum precision, and increase it
* Add NUMERIC division operator that doesn't round?
***************
*** 173,186 ****
* Have sequence dependency track use of DEFAULT sequences,
seqname.nextval?
! * Disallow changing default expression of a SERIAL column?
* Fix data types where equality comparison isn't intuitive, e.g. box
! * Prevent INET cast to CIDR if the unmasked bits are not zero, or
zero the bits
! * Prevent INET cast to CIDR from droping netmask, SELECT '1.1.1.1'::inet::cidr
* Allow INET + INT4 to increment the host part of the address, or
throw an error on overflow
! * Add 'tid != tid ' operator for use in corruption recovery
* Dates and Times
--- 173,186 ----
* Have sequence dependency track use of DEFAULT sequences,
seqname.nextval?
! * %Disallow changing default expression of a SERIAL column?
* Fix data types where equality comparison isn't intuitive, e.g. box
! * %Prevent INET cast to CIDR if the unmasked bits are not zero, or
zero the bits
! * %Prevent INET cast to CIDR from droping netmask, SELECT
'1.1.1.1'::inet::cidr
* Allow INET + INT4 to increment the host part of the address, or
throw an error on overflow
! * %Add 'tid != tid ' operator for use in corruption recovery
* Dates and Times
***************
*** 217,223 ****
* Arrays
o Allow NULLs in arrays
! o Allow MIN()/MAX() on arrays
o Delay resolution of array expression's data type so assignment
coercion can be performed on empty array expressions
o Modify array literal representation to handle array index lower bound
--- 217,223 ----
* Arrays
o Allow NULLs in arrays
! o %Allow MIN()/MAX() on arrays
o Delay resolution of array expression's data type so assignment
coercion can be performed on empty array expressions
o Modify array literal representation to handle array index lower bound
***************
*** 251,257 ****
make time reporting more consistent and will allow reporting of
the statement start time.
! * Add pg_get_acldef(), pg_get_typedefault(), and pg_get_attrdef()
* Allow to_char() to print localized month names
* Allow functions to have a schema search path specified at creation time
* Allow substring/replace() to get/set bit values
--- 251,257 ----
make time reporting more consistent and will allow reporting of
the statement start time.
! * %Add pg_get_acldef(), pg_get_typedefault(), and pg_get_attrdef()
* Allow to_char() to print localized month names
* Allow functions to have a schema search path specified at creation time
* Allow substring/replace() to get/set bit values
***************
*** 300,315 ****
Views / Rules
=============
! * Automatically create rules on views so they are updateable, per SQL99
We can only auto-create rules for simple views. For more complex
cases users will still have to write rules.
* Add the functionality for WITH CHECK OPTION clause of CREATE VIEW
* Allow NOTIFY in rules involving conditionals
! * Have views on temporary tables exist in the temporary namespace
* Allow temporary views on non-temporary tables
! * Allow RULE recompilation
SQL Commands
--- 300,315 ----
Views / Rules
=============
! * %Automatically create rules on views so they are updateable, per SQL99
We can only auto-create rules for simple views. For more complex
cases users will still have to write rules.
* Add the functionality for WITH CHECK OPTION clause of CREATE VIEW
* Allow NOTIFY in rules involving conditionals
! * %Have views on temporary tables exist in the temporary namespace
* Allow temporary views on non-temporary tables
! * %Allow RULE recompilation
SQL Commands
***************
*** 329,337 ****
* Add CORRESPONDING BY to UNION/INTERSECT/EXCEPT
* -Allow REINDEX to rebuild all database indexes
* Add ROLLUP, CUBE, GROUPING SETS options to GROUP BY
! * Allow SET CONSTRAINTS to be qualified by schema/table name
! * Allow TRUNCATE ... CASCADE/RESTRICT
! * Add a separate TRUNCATE permission
Currently only the owner can TRUNCATE a table because triggers are not
called, and the table is locked in exclusive mode.
--- 329,337 ----
* Add CORRESPONDING BY to UNION/INTERSECT/EXCEPT
* -Allow REINDEX to rebuild all database indexes
* Add ROLLUP, CUBE, GROUPING SETS options to GROUP BY
! * %Allow SET CONSTRAINTS to be qualified by schema/table name
! * %Allow TRUNCATE ... CASCADE/RESTRICT
! * %Add a separate TRUNCATE permission
Currently only the owner can TRUNCATE a table because triggers are not
called, and the table is locked in exclusive mode.
***************
*** 363,369 ****
triggers?)
* Add NOVICE output level for helpful messages like automatic sequence/index
creation
! * Add COMMENT ON for all cluster global objects (roles, databases
and tablespaces)
* -Add an option to automatically use savepoints for each statement in a
multi-statement transaction.
--- 363,369 ----
triggers?)
* Add NOVICE output level for helpful messages like automatic sequence/index
creation
! * %Add COMMENT ON for all cluster global objects (roles, databases
and tablespaces)
* -Add an option to automatically use savepoints for each statement in a
multi-statement transaction.
***************
*** 416,426 ****
* ALTER
! o Have ALTER TABLE RENAME rename SERIAL sequence names
! o Add ALTER DOMAIN TYPE
! o Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME
! o Allow ALTER TABLE to change constraint deferrability and actions
! o Disallow dropping of an inherited constraint
o -Allow objects to be moved to different schemas
o Allow ALTER TABLESPACE to move to different directories
o Allow databases to be moved to different tablespaces
--- 416,426 ----
* ALTER
! o %Have ALTER TABLE RENAME rename SERIAL sequence names
! o %Add ALTER DOMAIN TYPE
! o %Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME
! o %Allow ALTER TABLE to change constraint deferrability and actions
! o %Disallow dropping of an inherited constraint
o -Allow objects to be moved to different schemas
o Allow ALTER TABLESPACE to move to different directories
o Allow databases to be moved to different tablespaces
***************
*** 429,435 ****
Currently non-global system tables must be in the default database
tablespace. Global system tables can never be moved.
! o Prevent child tables from altering constraints like CHECK that were
inherited from the parent table
--- 429,435 ----
Currently non-global system tables must be in the default database
tablespace. Global system tables can never be moved.
! o %Prevent child tables from altering constraints like CHECK that were
inherited from the parent table
***************
*** 445,451 ****
store heap rows in hashed groups, perhaps using a user-supplied
hash function.
! o Add default clustering to system tables
To do this, determine the ideal cluster index for each system
table and set the cluster setting during initdb.
--- 445,451 ----
store heap rows in hashed groups, perhaps using a user-supplied
hash function.
! o %Add default clustering to system tables
To do this, determine the ideal cluster index for each system
table and set the cluster setting during initdb.
***************
*** 459,465 ****
processed, with ROLLBACK on COPY failure.
o -Allow COPY to understand \x as a hex byte
! o Have COPY return the number of rows loaded/unloaded?
o -Allow COPY to optionally include column headings in the first line
o -Allow COPY FROM ... CSV to interpret newlines and carriage
returns in data
--- 459,465 ----
processed, with ROLLBACK on COPY failure.
o -Allow COPY to understand \x as a hex byte
! o %Have COPY return the number of rows loaded/unloaded?
o -Allow COPY to optionally include column headings in the first line
o -Allow COPY FROM ... CSV to interpret newlines and carriage
returns in data
***************
*** 468,474 ****
* GRANT/REVOKE
o Allow column-level privileges
! o Allow GRANT/REVOKE permissions to be applied to all schema objects
with one command
The proposed syntax is:
--- 468,474 ----
* GRANT/REVOKE
o Allow column-level privileges
! o %Allow GRANT/REVOKE permissions to be applied to all schema objects
with one command
The proposed syntax is:
***************
*** 491,497 ****
o Prevent DROP TABLE from dropping a row referenced by its own open
cursor?
! o Allow pooled connections to list all open WITH HOLD cursors
Because WITH HOLD cursors exist outside transactions, this allows
them to be listed so they can be closed.
--- 491,497 ----
o Prevent DROP TABLE from dropping a row referenced by its own open
cursor?
! o %Allow pooled connections to list all open WITH HOLD cursors
Because WITH HOLD cursors exist outside transactions, this allows
them to be listed so they can be closed.
***************
*** 585,606 ****
* pg_dump
! o Have pg_dump use multi-statement transactions for INSERT dumps
! o Allow pg_dump to use multiple -t and -n switches [pg_dump]
! o Add dumping of comments on composite type columns
! o Add dumping of comments on index columns
! o Replace crude DELETE FROM method of pg_dumpall --clean for
cleaning of roles with separate DROP commands
o -Add dumping and restoring of LOB comments
o Stop dumping CASCADE on DROP TYPE commands in clean mode
! o Add full object name to the tag field. eg. for operators we need
'=(integer, integer)', instead of just '='.
o Add pg_dumpall custom format dumps.
This is probably best done by combining pg_dump and pg_dumpall
into a single binary.
! o Add CSV output format
o Update pg_dump and psql to use the new COPY libpq API (Christopher)
o Remove unnecessary abstractions in pg_dump source code
--- 585,606 ----
* pg_dump
! o %Have pg_dump use multi-statement transactions for INSERT dumps
! o %Allow pg_dump to use multiple -t and -n switches [pg_dump]
! o %Add dumping of comments on composite type columns
! o %Add dumping of comments on index columns
! o %Replace crude DELETE FROM method of pg_dumpall --clean for
cleaning of roles with separate DROP commands
o -Add dumping and restoring of LOB comments
o Stop dumping CASCADE on DROP TYPE commands in clean mode
! o %Add full object name to the tag field. eg. for operators we need
'=(integer, integer)', instead of just '='.
o Add pg_dumpall custom format dumps.
This is probably best done by combining pg_dump and pg_dumpall
into a single binary.
! o %Add CSV output format
o Update pg_dump and psql to use the new COPY libpq API (Christopher)
o Remove unnecessary abstractions in pg_dump source code
***************
*** 618,624 ****
o Use backend PREPARE/EXECUTE facility for ecpg where possible
o Implement SQLDA
o Fix nested C comments
! o sqlwarn[6] should be 'W' if the PRECISION or SCALE value specified
o Make SET CONNECTION thread-aware, non-standard?
o Allow multidimensional arrays
o Add internationalized message strings
--- 618,624 ----
o Use backend PREPARE/EXECUTE facility for ecpg where possible
o Implement SQLDA
o Fix nested C comments
! o %sqlwarn[6] should be 'W' if the PRECISION or SCALE value specified
o Make SET CONNECTION thread-aware, non-standard?
o Allow multidimensional arrays
o Add internationalized message strings
***************
*** 653,659 ****
* Allow statement-level triggers to access modified rows
* Support triggers on columns (Greg Sabino Mullane)
! * Remove CREATE CONSTRAINT TRIGGER
This was used in older releases to dump referential integrity
constraints.
--- 653,659 ----
* Allow statement-level triggers to access modified rows
* Support triggers on columns (Greg Sabino Mullane)
! * %Remove CREATE CONSTRAINT TRIGGER
This was used in older releases to dump referential integrity
constraints.
***************
*** 804,810 ****
* Improve commit_delay handling to reduce fsync()
* Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options
* -Allow multiple blocks to be written to WAL with one write()
! * Add an option to sync() before fsync()'ing checkpoint files
* Add program to test if fsync has a delay compared to non-fsync
--- 804,810 ----
* Improve commit_delay handling to reduce fsync()
* Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options
* -Allow multiple blocks to be written to WAL with one write()
! * %Add an option to sync() before fsync()'ing checkpoint files
* Add program to test if fsync has a delay compared to non-fsync
***************
*** 902,915 ****
VACUUM can look at just those pages rather than the entire table. In
the event of a system crash, the bitmap would probably be invalidated.
! * Add system view to show free space map contents
* Auto-vacuum
o -Move into the backend code
o Use free-space map information to guide refilling
! o Do VACUUM FULL if table is nearly empty?
o Improve xid wraparound detection by recording per-table rather
than per-database
--- 902,915 ----
VACUUM can look at just those pages rather than the entire table. In
the event of a system crash, the bitmap would probably be invalidated.
! * %Add system view to show free space map contents
* Auto-vacuum
o -Move into the backend code
o Use free-space map information to guide refilling
! o %Do VACUUM FULL if table is nearly empty?
o Improve xid wraparound detection by recording per-table rather
than per-database
***************
*** 1075,1081 ****
* Rename some /contrib modules from pg* to pg_*
* Move some things from /contrib into main tree
* Move some /contrib modules out to their own project sites
! * Remove warnings created by -Wcast-align
* Move platform-specific ps status display info from ps_status.c to ports
* Add optional CRC checksum to heap and index pages
* Improve documentation to build only interfaces (Marc)
--- 1075,1081 ----
* Rename some /contrib modules from pg* to pg_*
* Move some things from /contrib into main tree
* Move some /contrib modules out to their own project sites
! * %Remove warnings created by -Wcast-align
* Move platform-specific ps status display info from ps_status.c to ports
* Add optional CRC checksum to heap and index pages
* Improve documentation to build only interfaces (Marc)
***************
*** 1106,1111 ****
--- 1106,1112 ----
* Fix cross-compiling of time zone database via 'zic'
* Fix sgmltools so PDFs can be generated with bookmarks
* -Add C code on Unix to copy directories for use in creating new databases
+ * %Clean up compiler warnings (especially with gcc version 4)
* Win32
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
