Open Items - Mailing list pgsql-hackers

I have annotated the open items:

---------------------------------------------------------------------------

                              PostgreSQL 8.0 Open Items                              =========================

Current version at http://candle.pha.pa.us/cgi-bin/pgopenitems.

Changes
-------
* Win32o fix query cancel in psql
This requires a new thread to handle the control-C signal
o fix shared memory on Win2k terminal server
We might be able to just mark this as not supported.
o Handle "lost signals" on backend startup (eg. shutdown,  config file changes, etc);  signals are SIG_DFL on startup
The problem here is that the postmaster might send signals to achild before the signal handlers are installed.  We
don'thavethis problem on unix because we fork and inherit the signalhandlers.
 

* Tablespaceo fix ambiguity for objects using default tablespaces
CREATE TABLE test(a int4) tablespace loc;CREATE UNIQUE INDEX test_a_idx3 ON test(a) tablespace pg_default;
Index test_a_idx3 has a tablespace value of zero.  pg_get_indexdef()thinks the index is in loc even though it is in
pg_default. Andif you move test the index is thought to move too.  The confusionis that there are not separate defaults
fordatabase/schema/table.
 
o fix case where template db already uses target tablespace
-- from database testCREATE tablespace blah location '/bjm/tmp';CREATE TABLE foo (i int) tablespace blah;CREATE
DATABASEfoo tablespace blah template test;ERROR:  could not initialize database directoryDETAIL:  Directory
"/u/pgsql/data/pg_tblspc/17232/17235"already exists.
 
o remove non-portable TABLESPACE clause from CREATE TABLE and  use a new default_tablespace SET variable
This same method is used for WITH/WITHOUT OIDS.

* allow libpq to check parameterized data types
* adjust bgwriter defaults, allow disabling
* synchonize supported encodings and docs

Completed Since Previoius Beta
------------------------------
* cleanup FRONTEND use in /port, malloc, elog
* update encoding list to include win1250
* make pgxs install by default
* Tablespaceo fix error message when creating objects in schema that has a  dropped tablespace as its default
* Win32o disable readline-required psql optionso fix SSL compileso add binary version stampso fix signal-safe socket
handlerfor SSLo start pg_autovacuum easilyo remove log timezone string from log_line_prefix '%t'o fix MinGW libpq to
exportonly required symbolso fix MSVC build to export SSL symbols
 


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073