Re: [PATCHES] Partition: use triggers instead of rules

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Fetter <david(at)fetter(dot)org>
Cc: NikhilS <nikkhils(at)gmail(dot)com>, Gregory Stark <stark(at)enterprisedb(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Michael Paesold <mpaesold(at)gmx(dot)at>, "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, PostgreSQL Docs <pgsql-docs(at)postgresql(dot)org>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [PATCHES] Partition: use triggers instead of rules
Date: 2007-12-02 19:21:31
Message-ID: 23125.1196623291@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-patches

David Fetter <david(at)fetter(dot)org> writes:
> On Fri, Nov 30, 2007 at 12:34:05PM +0530, NikhilS wrote:
>> Another reason to go along with triggers is that "COPY" honors
>> triggers, but does not honor rules. While trying to do bulk inserts
>> into a parent of partitioned tables where rules are being employed,
>> the COPY operation will not be so straightforward.

> Does my latest patch attached address this well enough?

Applied with revisions and extensions. (I take it you hadn't actually
tested the example :-()

regards, tom lane

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Greg Smith 2007-12-02 20:58:56 Re: full_page_writes = off?
Previous Message Albert Cervera i Areny 2007-12-02 17:34:17 Re: About contrib modules

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-12-03 04:22:54 pgsql: Remove obsoleted README files.
Previous Message Steve Singer 2007-12-02 06:51:09 Re: Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?