lock problem

From: marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Subject: lock problem
Date: 2005-08-16 16:40:39
Message-ID: 20050816164040.71976.qmail@web32603.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi all

I have a lock problem, one select query freeze my
application, the query in question is on complex
select , with many join's, but select all of them.
The select * from pg_catalog.pg_locks show many rows
while the query freeze my aplication.
the aplication use ODBC .
any ideas?.
any help wellcomed
best
MDC

pd: what query show pg_locks ? , have a view ?
sorry for my poor english and thanks for your time.

__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Murphy 2005-08-16 16:47:13 table clustering brings joy
Previous Message Alvaro Herrera 2005-08-16 16:27:53 Re: ~/pgpass