7.2 stuff
От | Christopher Kings-Lynne |
---|---|
Тема | 7.2 stuff |
Дата | |
Msg-id | ECEHIKNFIMMECLEBJFIGGEALCBAA.chriskl@familyhealth.com.au обсуждение исходный текст |
Ответы |
Re: 7.2 stuff
(Tom Lane <tgl@sss.pgh.pa.us>)
Re: 7.2 stuff (Bruce Momjian <pgman@candle.pha.pa.us>) Re: 7.2 stuff (Bruce Momjian <pgman@candle.pha.pa.us>) Re: 7.2 stuff (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: