Re: 7.2 stuff

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 7.2 stuff
Date: 2001-06-21 13:57:50
Message-ID: 200106211357.f5LDvo012274@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


So you have at ~2 months.

> 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(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

  • 7.2 stuff at 2001-06-21 03:18:09 from Christopher Kings-Lynne

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-06-21 14:07:06 Re: stuck spin lock with many concurrent users
Previous Message Jason Tishler 2001-06-21 12:56:11 Re: [current] readline breakage