[ADMIN] How to make data changes inside trigger function visible to the top level statement ?

2012-08-06 Thread Haifeng Liu
Hello, I am doing table partitioning, all is ok except that after executing 'insert' sql statement I can't get affected rows, it always be 0. After searching on the documents, I found that row changes inside trigger function is not visible to the top level statement. Partition table using a tr

Re: [ADMIN] How to make data changes inside trigger function visible to the top level statement ?

2012-08-06 Thread Craig Ringer
On 08/06/2012 06:50 PM, Haifeng Liu wrote: Hello, I am doing table partitioning, all is ok except that after executing 'insert' sql statement I can't get affected rows, it always be 0. After searching on the documents, I found that row changes inside trigger function is not visible to the top

Re: [ADMIN] Timeout error on pgstat

2012-08-06 Thread Anibal David Acosta
Is probably that the cause of this behavior are many many dead tuples in the table.? De: Anibal David Acosta [mailto:a...@devshock.com] Enviado el: miƩrcoles, 01 de agosto de 2012 04:27 p.m. Para: pgsql-admin@postgresql.org Asunto: Timeout error on pgstat I have a lot (maybe 1 eve