Help with rules

From: Chris Hoover <revoohc(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Help with rules
Date: 2005-08-05 19:29:28
Message-ID: 1d219a6f05080512292b8c0e2f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I need some help. I was looking at this e-mail
(http://archives.postgresql.org/pgsql-performance/2005-06/msg00369.php)
and it gave me a good idea on how to fake partitioning.

I have created a test database with serveral identical tables.
Table_2003, Table_2004, Table_2005, etc

I then created the view "test_view" and defined as a union all of all
of the tables.

I have created several do instead insert rules trying to force the
data into the correct table when I load from production data into the
view/tables. However, PostgreSQL will not preform the inserts when
trying to load the data. It complains about needing an uncondition ON
INSERT DO INSTEAD rule.

Is there anyway to have a rule that would correctly insert the data
from the view into the correct underlying table when loading a file
with several years of data?

Thanks,

Chris

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2005-08-05 19:49:22 Re: tweak config file to increase pg_dump speed on pg 8.02
Previous Message D Kavan 2005-08-05 19:28:35 tweak config file to increase pg_dump speed on pg 8.02