RE: DROP CONSTRAINT (UNIQUE) preliminary support
От | Christopher Kings-Lynne |
---|---|
Тема | RE: DROP CONSTRAINT (UNIQUE) preliminary support |
Дата | |
Msg-id | ECEHIKNFIMMECLEBJFIGGEPECAAA.chriskl@familyhealth.com.au обсуждение исходный текст |
Ответ на | Re: DROP CONSTRAINT (UNIQUE) preliminary support (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: DROP CONSTRAINT (UNIQUE) preliminary support
|
Список | pgsql-patches |
> How are we doing on this patch? Don't commit it! I just want feedback - however I prolly won't worry about it until I've finished fully implementing DROP CONSTRAINT to support all types of constraints. > > Hi all, > > > > This patch allows ALTER TABLE/DROP CONSTRAINT to drop UNIQUE > constraints by > > dropping the relevant index. > > > > This is a prelim patch that I need comment on (The @@ > comments), and I've > > edited some things out by hand, so I don't recommend applying > it to anything > > just yet. > > > > I have added an IsIndex function to indexcmds.c and a > RemoveUniqueConstraint > > to heap.c, plus modified command.c's AlterTableDropConstraint > function to > > call RemoveUniqueConstraint. > > > > Note that I have disabled inheritance support for unique > constraints - since > > it's impossible to have two indices of the same name anyway... > > > > Comments please. > > > > Chris > > [ Attachment, skipping... ] > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" 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, Pennsylvania 19026 >
В списке pgsql-patches по дате отправления: