Re: [GENERAL] strange thing with partitioning / rules / plpgsql

2007-01-29 Thread Alvaro Herrera
Tomas Vondra wrote: > So far everything seems ok, but let's create another child table > [...] > == > > and do the execution plan again: > > == > > EXPLAIN EX

[GENERAL] strange thing with partitioning / rules / plpgsql

2007-01-29 Thread Tomas Vondra
Hello, I've encountered a 'strange' behavior when using partitioning and prepared statements (or SQL in PL/pgSQL procedures) on 8.1.5. Imagine you have a table partitioned by an ID (say in 1 milion blocks), thus you have an empty 'parent' table PARENT and child tables CHILD_0, CHILD_1, ... ==