pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Help with rules
2+ messages / 1 participants
[nested] [flat]

* Help with rules
@ 2005-08-05 19:29  Chris Hoover <revoohc@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Chris Hoover @ 2005-08-05 19:29 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Fwd: Help with rules
@ 2005-08-11 14:04  Chris Hoover <revoohc@gmail.com>
  parent: Chris Hoover <revoohc@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Chris Hoover @ 2005-08-11 14:04 UTC (permalink / raw)
  To: pgsql-admin

Sorry for the repost, but can anyone comment on this, please?

---------- Forwarded message ----------
From: Chris Hoover <revoohc@gmail.com>
Date: Aug 5, 2005 3:29 PM
Subject: Help with rules
To: pgsql-admin@postgresql.org


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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-08-11 14:04 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-05 19:29 Help with rules Chris Hoover <revoohc@gmail.com>
2005-08-11 14:04 ` Chris Hoover <revoohc@gmail.com>

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