Re: Partition: use triggers instead of rules

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: PostgreSQL Docs <pgsql-docs(at)postgresql(dot)org>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Partition: use triggers instead of rules
Date: 2007-11-28 20:39:04
Message-ID: 20071128123904.672beb8b@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-patches

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 28 Nov 2007 12:26:15 -0800
David Fetter <david(at)fetter(dot)org> wrote:

> Folks,
>
> Best practices for partitioning so far have shown that TRIGGERs are
> better than RULEs for most cases. Please find attached a patch which
> reflects this.
>
> Thanks to Robert Treat for help putting this together :)
>
> Cheers,
> David.

+1

Joshua D. Drake

- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHTdHoATb/zqfZUUQRAnpWAJ9xHqMnNorANuS9r8Hm90tn2bmZIwCglwlq
D7Q1C5vcbvQ/JiqVcv0wCho=
=NcWZ
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David Fetter 2007-11-28 20:41:20 Re: Partition: use triggers instead of rules
Previous Message Tom Lane 2007-11-28 20:38:01 Re: Two fixes for plpgsql.sgml

Browse pgsql-patches by date

  From Date Subject
Next Message David Fetter 2007-11-28 20:41:20 Re: Partition: use triggers instead of rules
Previous Message David Fetter 2007-11-28 20:26:15 Partition: use triggers instead of rules