Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-docspgsql-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

pgsql-docs by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group