Re: update problem in partitioned tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: update problem in partitioned tables
Дата
Msg-id 23289.1189613031@sss.pgh.pa.us
обсуждение исходный текст
Ответ на update problem in partitioned tables  ("Josh Harrison" <joshques@gmail.com>)
Ответы Re: update problem in partitioned tables  ("Josh Harrison" <joshques@gmail.com>)
Список pgsql-general
"Josh Harrison" <joshques@gmail.com> writes:
> Now I create this function to redirect the inserts  and updates on the
> master table.

Uh ... there never will be any updates in the master table, since it
hasn't got any entries.

What you'd need is an insert trigger on the master and update triggers
on each child table.  I think the logic of this trigger is wrong for
the update case anyway.

            regards, tom lane

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

Предыдущее
От: "Josh Harrison"
Дата:
Сообщение: update problem in partitioned tables
Следующее
От: Mike Charnoky
Дата:
Сообщение: problems with large table