Diabling constraints

Поиск
Список
Период
Сортировка
От Linh Luong
Тема Diabling constraints
Дата
Msg-id 3BA27616.D14F6D8D@computalog.com
обсуждение исходный текст
Ответы Re: Diabling constraints  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
Hi,

I am wondering is there any way of disabling constraints that was
created after the table itself was created.

I know I can drop the trigger that the constraint creates.  However, I
need to make this change in several postgres database and it seems like
the the tgname that is required to remove the constraint is generate by
the system so I can't just go
    drop trigger "<tgname>" on <tablename> because tgname is different in
all the database I need to modify.

Any ideas in disabling or removing them without harding the tgname..
Thanks

--
LL

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

Предыдущее
От: "Eric Ridge"
Дата:
Сообщение: Re: count of occurences
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Working with dates and queries