On Wed, Nov 17, 2010 at 1:00 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > =?ISO-8859-1?Q?Jorge_Ar=E9valo?= <jorge.arevalo@xxxxxxxxxxxxxxxx> writes: >> Well, the query works if executed in psql client. Seems to be a Python >> problem. I'll execute the rest of the loop queries in the client, just >> in case. > >> But in case is a Python problem, why does it affect the postgres >> process, causing a crash? > > Is the query parameterized when issued from Python? If so it might work > differently. > > regards, tom lane > Yes, it takes the table names from another query (select table_names from other_table), and the fields names from a XML file. Can the query which fetch the table names cause a memory problem? Seems weird -- Jorge Arévalo Internet & Mobilty Division, DEIMOS jorge.arevalo@xxxxxxxxxxxxxxxx http://mobility.grupodeimos.com/ http://gis4free.wordpress.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general