Re: Partitioning triggers doc patch

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема Re: Partitioning triggers doc patch
Дата
Msg-id CAJKUy5jkACskX=JU7HF2ce9-v3nCTmbvX41=aDX0J9bUSL8Wbw@mail.gmail.com
обсуждение исходный текст
Ответ на Partitioning triggers doc patch  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: Partitioning triggers doc patch
Список pgsql-hackers
On Mon, Mar 12, 2012 at 10:41 AM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
> Attached is a doc patch based on a suggestion by Rural Hunter to
> address something he found confusing while setting up partitioning.
>
> Original thread is here:
>
> http://archives.postgresql.org/pgsql-admin/2012-03/msg00066.php
>

you can create trigger that execute before the trigger that redirect
to the partition, for example to stamp the time or the user... so it
should state something like i said about constraints

"""
Do not define any check constraints on this table, unless you intend
them to be applied equally to all partitions.
"""

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: foreign key locks, 2nd attempt
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Partitioning triggers doc patch