Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
Дата
Msg-id 20030811061208.T72304-100000@megazone.bigpanda.com
обсуждение исходный текст
Ответ на [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3  (BenLaKnet <benlaknet@icqmail.com>)
Ответы Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
Список pgsql-sql
On Mon, 11 Aug 2003, [ISO-8859-1] Beno�t Bournon wrote:

> No trigger
>
> Just triggers for foreign key in spectacle and none in spectacle_v
>
> How is it possible to verify triggers for foreign keys ?

Generally a select on pg_trigger.  Each foreign key should have 3
triggers, 1 on the referencing table and 2 on the referenced. You find the
tables involved by crossreferencing tgrelid against the oid of the row
in pg_class.

Can you send the results of a pg_dump -s?



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

Предыдущее
От: "Eric Anderson Vianet SAO"
Дата:
Сообщение: update system table?
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: sub-sel/group problem