Re: Partitioning triggers doc patch - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: Partitioning triggers doc patch
Date
Msg-id CAJKUy5jkACskX=JU7HF2ce9-v3nCTmbvX41=aDX0J9bUSL8Wbw@mail.gmail.com
Whole thread Raw
In response to Partitioning triggers doc patch  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Partitioning triggers doc patch  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List 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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: foreign key locks, 2nd attempt
Next
From: "Kevin Grittner"
Date:
Subject: Re: Partitioning triggers doc patch