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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Error messages
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: RE: Setuid functions