lock problem - Mailing list pgsql-general

From marcelo Cortez
Subject lock problem
Date
Msg-id 20050816164040.71976.qmail@web32603.mail.mud.yahoo.com
Whole thread Raw
Responses Re: lock problem  (Richard Huxton <dev@archonet.com>)
List 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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: ~/pgpass
Next
From: Kevin Murphy
Date:
Subject: table clustering brings joy