Обсуждение: rename a constraint?

Поиск
Список
Период
Сортировка

rename a constraint?

От
Kevin Kempter
Дата:
Hi List;

Is there a method/syntax I can use to rename a constraint ?

Thx

/Kevin

Re: rename a constraint?

От
Decibel!
Дата:
On Thu, Aug 30, 2007 at 02:42:43PM -0600, Kevin Kempter wrote:
> Hi List;
>
> Is there a method/syntax I can use to rename a constraint ?

Not an official one, no... you'll need to create a new one then drop the
old (don't do it the other way or it'll have to re-check everything).

You might also be able to UPDATE the appropriate catalog, but I'm not
sure how safe that is.
--
Decibel!, aka Jim Nasby                        decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Вложения