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

From: David Fetter <david(at)fetter(dot)org>
To: NikhilS <nikkhils(at)gmail(dot)com>
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-01 04:56:20
Message-ID: 20071201045620.GW27157@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-patches

On Fri, Nov 30, 2007 at 12:34:05PM +0530, NikhilS wrote:
> Hi,
>
> 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.

Folks,

Does my latest patch attached address this well enough?

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

Attachment Content-Type Size
partition.diff text/plain 8.4 KB

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message rihad 2007-12-01 08:02:23 full_page_writes = off?
Previous Message Simon Riggs 2007-11-30 09:54:19 Re: [PATCHES] Partition: use triggers instead of rules

Browse pgsql-patches by date

  From Date Subject
Next Message Pavel Stehule 2007-12-01 10:43:52 plpgsql, forc statement
Previous Message Euler Taveira de Oliveira 2007-12-01 00:54:06 pt_BR FAQ update