[ADMIN] problem with rules

2010-10-28 Thread Uwe Bartels
Hi, i'm trying to reorganize a big table without having a downtime at all. I'm trying to realize this via partitioning and rules. - step 1 preparation create table uglybloatedtable (id bigserial, textfield text, primary key(id)); INSERT INTO uglybloatedtable (textfield) values (''); INSERT INTO

[ADMIN] Problem with rules

2005-08-25 Thread Chris Hoover
I am having a problem with the rule system in 7.3.4. I have a view with an on insert do instead rule that is calling a function and passing new.*. When try to insert a row into the view, I get ERROR: ResolveNew: can't handle whole-tuple reference. I was working with this in 8.0 on an RD