Re: 7.2 stuff - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: 7.2 stuff
Date
Msg-id 200111270201.fAR21V522158@candle.pha.pa.us
Whole thread Raw
In response to 7.2 stuff  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: 7.2 stuff
List pgsql-hackers
Christopher, do you want any of this added to the TODO?

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

> 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
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: insert/update/delete statements returning a query response
Next
From: Tatsuo Ishii
Date:
Subject: TODO