This is a nice list and all are good items. People should be able to
help you if you encounter problems.
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
-- 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,
Pennsylvania19026