I'm not sure about this one, but it should be possible to change the type of
a column without vacuum, to reoorder the columns, change the name,...

It would allow people who design GUIs to PG to do a very nice designer
interface (like on MS SQL7.0).

Also on the design part, the UML standard and others allow the drawing of
interfaces (ArgoUML, Dia,..). Someone could work out an export from UML
graph to PG Table Creation.

I'm still working on a new geographic type (geoobj) for PG follwing ISO
standards. Except the standard is still a draft. So I can't meet any
deadline... (fmaps.sourceforge.net)

Franck Martin
Network and Database Development Officer
SOPAC South Pacific Applied Geoscience Commission
Fiji
E-mail: franck@sopac.org <mailto:franck@sopac.org> 
Web site: http://www.sopac.org/ <http://www.sopac.org/> 
Support FMaps: http://fmaps.sourceforge.net/ <http://fmaps.sourceforge.net/>


This e-mail is intended for its addresses only. Do not forward this e-mail
without approval. The views expressed in this e-mail may not be necessarily
the views of SOPAC.



-----Original Message-----
From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
Sent: Friday, 11 May 2001 5:21 
To: PostgreSQL-development
Subject: [HACKERS] 7.2 items


Here is a small list of big TODO items.  I was wondering which ones
people were thinking about for 7.2?

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

* Add replication of distributed databases [replication]
	o automatic fallover
	o load balancing
	o master/slave replication
	o multi-master replication
	o partition data across servers
	o sample implementation in contrib/rserv
	o queries across databases or servers (two-phase commit)
* Point-in-time data recovery using backup and write-ahead log
* Allow row re-use without vacuum (Vadim)
* Add the concept of dataspaces/tablespaces [tablespaces]
* Allow better control over user privileges [privileges]
* Allow elog() to return error codes, module name, file name, line
  number, not just messages [elog]
* Allow international error message support and add error codes [elog]
* Make binary/file in/out interface for TOAST columns
* Large object interface improvements
* Allow inherited tables to inherit index, UNIQUE constraint, and primary
key
  [inheritance]
* Add ALTER TABLE DROP COLUMN feature [drop]
* Add ALTER TABLE ... DROP CONSTRAINT
* Automatically drop constraints/functions when object is dropped

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Fri, 11 May 2001 10:19:20 +1200
Franck Martin <Franck@sopac.org>
RE: 7.2 items