Re: Partitioning triggers doc patch

Jaime Casanova <jaime@2ndquadrant.com>

From: Jaime Casanova <jaime@2ndquadrant.com>

To: Kevin Grittner <Kevin.Grittner@wicourts.gov>

Cc: pgsql-hackers@postgresql.org, Rural Hunter <ruralhunter@gmail.com>

Date: 2012-03-12T17:31:21Z

Lists: 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