Re: [SQL] ALTER TABLE ... DROP CONSTRAINT

Поиск
Список
Период
Сортировка
От Chad Thompson
Тема Re: [SQL] ALTER TABLE ... DROP CONSTRAINT
Дата
Msg-id 001b01c356b7$3791c5d0$32021aac@chad
обсуждение исходный текст
Ответ на ALTER TABLE ... DROP CONSTRAINT  (Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>)
Список pgsql-general
 
Hi all!
 
    Who can tell me what postgres version supports ALTER TABLE... DROP CONSTRAINT without
the need of droping the table to remove a simple coinstraint. (link)

                                   >\\\!/<     55 11 5080 9283
                                   !_"""_!     Elielson Fontanezi
                                   (O) (o)     PRODAM - Technical Support Analyst
-------------------------------oOOO--(_)--OOOo-----------------------------------
    
Success usually comes to those who are too busy to be looking for it.
                           
oooo0          0oooo
---------------------------(    )----------(    )--------------------------------
                            \  (            )  /
                             \_/            \_/

 
7.3 supports the drop constraint.  The only exception begin if you upgraded your database.  It keeps the existing trigger like constraints if youve moved from 7.1 or 7.2.  But these triggers can be dropped as well.
 
HTH
Chad
 
P.S. Great signature! :-)

В списке pgsql-general по дате отправления:

Предыдущее
От: Robert Partyka
Дата:
Сообщение: How to do?
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Integrating the field auto-increment