7.2 stuff

How far off is 7.2? Ages? I want to add the rest of the ALTER TABLE
functionality for 7.2, but I've just been busy - don't worry I haven't
forgotten!

This is my personal TODO list:

* ALTER TABLE ADD PRIMARY KEY
- Done, except code that detects whether or not a pk already exists
* ALTER TABLE ADD UNIQUE
- Done, except code that detects whether or not a unique key already exists
over the specified fields
* PSQL - SHOW FOREIGN KEYS
- Still working on a query. If I come up with a good one - would a catalog
view of them be useful?
* -ALTER TABLE DROP CHECK
- Already committed
* ALTER TABLE DROP PRIMARY KEY
- Done, will need review
* ALTER TABLE DROP UNIQUE
- Done, will need review
* ALTER TABLE DROP FOREIGN KEY
- Harder than I thought :) Working on it.
* Check that pgclass.relfkeys is being set correctly.
- Is pgclass.relfkeys being used at the moment?
* PG_DUMP DUMP CONSTRAINTS AS ALTER TABLE STATEMENTS
- Would be nice, once the alter statements above work.
* FIX 'RESTRICT' IN DROP CONSTRAINT DOCS
- It would be nice to have restrict/cascade as optional keywords at the
moment? At the moment, the grammar forces people to put the word 'restrict'
in, even though it does nothing.
* REGRESSION TESTS
- For all of the above
* WILDCARDS IN PG_DUMP
- It would be nice to be able to dump tables via wildcards, or once schemas
exist to dump an entire schema I guess.
* CHECK CREATING DUPLICATE NAMED FOREIGN KEYS
- I seem to be able to create duplicate named fk's, plus I think the
'<unnamed>' ones should be given auto name to make dropping constraint
easier...
* DOCUMENT PG_TRIGGER
- Doesn't seem to be in the system catalog documentation...
* MOVE ALTER CODE FROM heap.c/command.c INTO alter.c
- I get the feeling I'm filling up heap.c with lots of alter table crud
that is beginning to need its own file?

If anyone is super-interested in seeing my unposted code, feel free to ask
for it. (Or better yet, wants to finish the work ;) )

Chris