Re: [GENERAL] table partitioning pl/pgsql helpers

2007-06-04 Thread Enrico Sirola
Hi Robert, Il giorno 01/giu/07, alle ore 04:08, Robert Treat ha scritto: [...] We I set these up for our clients, I typically seperate the partition creation piece from the data insertion piece. (Mostly as partition creation, especially with rules, is a table locking event, which is better

Re: [GENERAL] table partitioning pl/pgsql helpers

2007-06-01 Thread Robert Treat
On Wednesday 30 May 2007 12:55, Enrico Sirola wrote: > Hello, > > I'm trying to write a trigger on insert which should insert the row > in another > table. The table on which to insert the row should be selected at > runtime and > it is not know in advance. For example, let's say we have a table wi

[GENERAL] table partitioning pl/pgsql helpers

2007-05-30 Thread Enrico Sirola
Hello, I'm trying to write a trigger on insert which should insert the row in another table. The table on which to insert the row should be selected at runtime and it is not know in advance. For example, let's say we have a table with two columns, a date and an integer. a row is inserted int