pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Fetter <david@fetter.org>
Cc: NikhilS <nikkhils@gmail.com>
Cc: Gregory Stark <stark@enterprisedb.com>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: Michael Paesold <mpaesold@gmx.at>
Cc: Jonah H. Harris <jonah.harris@gmail.com>
Cc: PostgreSQL Docs <pgsql-docs@postgresql.org>
Cc: PostgreSQL Patches <pgsql-patches@postgresql.org>
Subject: Re: [PATCHES] Partition: use triggers instead of rules
Date: Sun, 02 Dec 2007 14:21:31 -0500
Message-ID: <23125.1196623291@sss.pgh.pa.us> (raw)
In-Reply-To: <20071201045620.GW27157@fetter.org>
References: <474EDAE2.3010705@gmx.at>
	<474EE25E.3080304@commandprompt.com>
	<14455.1196353045@sss.pgh.pa.us>
	<474EE992.2050209@commandprompt.com>
	<87zlwxj7xu.fsf@oxford.xeocode.com>
	<20071129091359.206fd8f2@commandprompt.com>
	<87ve7lj6y8.fsf@oxford.xeocode.com>
	<20071129095233.67f2b913@commandprompt.com>
	<87d4tser8g.fsf@oxford.xeocode.com>
	<d3c4af540711292304k7092335ete0470fd896bbb2ab@mail.gmail.com>
	<20071201045620.GW27157@fetter.org>

David Fetter <david@fetter.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



view thread (38+ messages)

Message-ID: <23125.1196623291@sss.pgh.pa.us>
Permalink:  ../23125.1196623291@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/23125.1196623291@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, david@fetter.org, nikkhils@gmail.com, stark@enterprisedb.com, jd@commandprompt.com, mpaesold@gmx.at, jonah.harris@gmail.com, pgsql-patches@postgresql.org
  Subject: Re: [PATCHES] Partition: use triggers instead of rules
  In-Reply-To: <23125.1196623291@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox