On Tue, 5 Jun 2001, Christopher Kings-Lynne wrote:
> > > Just thought you might like to add
> > >
> > > * ALTER TABLE ADD PRIMARY KEY
> > > * ALTER TABLE ADD UNIQUE
> >
> > And what
> >
> > ALTER TABLE DROP PRIMARY KEY
> > ALTER TABLE DROP UNIQUE
> >
> > BTW, it's a little cosmetic feature if we have CREATE/DROP INDEX :-)
>
> Those two points are already mentioned - I have another 90% patch ready to
> go that will add that functionality as well...
As a question, are you doing anything to handle dropping referenced unique
constraints or are we just waiting on that until a referencing system
is built?
In response to
Responses
pgsql-hackers by date
| Next: | From: Tom Lane | Date: 2001-06-05 16:46:12 |
| Subject: Re: Strange query plan |
| Previous: | From: Jan Wieck | Date: 2001-06-05 15:37:23 |
| Subject: Re: Multiprocessor performance |