Re: [GENERAL] strange performance problem (SOLVED)

2009-03-01 Thread Linos
Linos escribió: Linos escribió: Linos escribió: Richard Huxton escribió: Linos wrote: Richard Huxton escribió: Linos wrote: 2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms sentencia: SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto", "id_seccion", "id_categoria"

Re: [GENERAL] strange performance problem (SOLVED)

2009-03-01 Thread Linos
Linos escribió: Linos escribió: Richard Huxton escribió: Linos wrote: Richard Huxton escribió: Linos wrote: 2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms sentencia: SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto", "id_seccion", "id_categoria" FROM "modelo_sub

Re: [GENERAL] function to return rows as columns?

2009-03-01 Thread Sim Zacks
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I think this approach have a problem (almost with my data), i have a > somewhat large number of different sizes, about 200 or so (although i > have a presented a limited example i now). Thanks anyway by the > alternative way to do it Andreas. > Actu

Re: [GENERAL] when to use "execute" in plpgsql?

2009-03-01 Thread Pavel Stehule
Hello > > My experience in this is just from 8.0 so I don't know if anything has > changed. In general, if tables are created or deleted within the > function then you want to use execute, as well as if the tables are > recreated in the course of a normal workflow. For example, if you have a > tab

Re: [GENERAL] when to use "execute" in plpgsql?

2009-03-01 Thread Sim Zacks
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Merlin Moncure wrote: > I'm not completely sure what the problem is because this is light on > detail, but here's a what I bet the problem is. static (that is, not > EXECUTE-ed) queries in pl/pgsql functions convert table references in > the function b

Re: [GENERAL] db_restore and xml data

2009-03-01 Thread Shahbaz A. Tyagi
The problem is sorted out, as it was in 2003 server and when we were comparing it with XP one. Thanks, Shahbaz A. Tyagi -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Peter Eisentraut Sent: Sunday, March 01, 2009 3:06

Re: [GENERAL] db_restore and xml data

2009-03-01 Thread Peter Eisentraut
On Friday 27 February 2009 19:09:57 Enrico Sirola wrote: > Hello, > I have a pgsql database hosting xml data in xml columns. The data, > have declarations at the beginning, so it is saved with > > XMLPARSE (DOCUMENT ) > > when I try to restore a database from dump, pg_restore complains > because t