Re: --//pgsql partitioning-///-------------------- - Mailing list pgsql-general

From Ow Mun Heng
Subject Re: --//pgsql partitioning-///--------------------
Date
Msg-id D1109E8B2FB53A45BDB60F8145905CE904B5359A@wdmyexbe03.my.asia.wdc.com
Whole thread Raw
In response to Re: --//pgsql partitioning-///--------------------  (Vick Khera <vivek@khera.org>)
Responses pg_dump native format will not restore correctly
List pgsql-general

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Vick Khera

> Here are two (not necessarily mutually exclusive) options for you:

>1) use triggers/rules on the master table and do all your inserts
>directed to it and have the trigger/rule do the right thing
>2) write your insert/update/delete statements to use the correct
>inherited table directly, and write a trigger on the master that
>denies any inserts.

#2 would have better performance than #1.

Use #1 only if you have no choice.


pgsql-general by date:

Previous
From: Michal Bicz
Date:
Subject: warm standby resume and take online problems
Next
From: Greg Smith
Date:
Subject: Re: warm standby resume and take online problems