Re: --//pgsql partitioning-///--------------------
От
Vick Khera
Тема
Re: --//pgsql partitioning-///--------------------
Дата
Msg-id
2968dfd60911040659w7014ec19o1fdd2d174e48e6c7@mail.gmail.com
Ответ на
--//pgsql partitioning-///-------------------- (shahrzad khorrami)
Список
Дерево обсуждения
--//pgsql partitioning-///-------------------- shahrzad khorrami <shahrzad.khorrami@gmail.com>
Re: --//pgsql partitioning-///-------------------- Vick Khera <vivek@khera.org>
Re: --//pgsql partitioning-///-------------------- "Ow Mun Heng" <ow.mun.heng@wdc.com>
pg_dump native format will not restore correctly "Scot Kreienkamp" <SKreien@la-z-boy.com>
Re: pg_dump native format will not restore correctly Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump native format will not restore correctly "Scot Kreienkamp" <SKreien@la-z-boy.com>
Re: pg_dump native format will not restore correctly Sam Mason <sam@samason.me.uk>
Re: pg_dump native format will not restore correctly "Scot Kreienkamp" <SKreien@la-z-boy.com>
Re: pg_dump native format will not restore correctly Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump native format will not restore correctly "Scot Kreienkamp" <SKreien@la-z-boy.com>
Re: --//pgsql partitioning-///-------------------- Wojtek <foo@twine.pl>
On Wed, Nov 4, 2009 at 4:49 AM, shahrzad khorrami wrote: > but problem here is how I can do something that when I insert data, the > master table remains empty > and just data inserted into inherited tables. > 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. Did you read the documentation on partitions? It covers this.
В списке pgsql-general по дате отправления
От: Tom Lane
Дата:
