Re: [GENERAL] Postgresql Database Lock Problem

2009-11-18 Thread shohorab hossain
Now I am using the following parameter to temporary resolve the locking problem statment_timeout = 20s With Thanks & Regards: ----- Shohorab Hossain - Original Message From: shohorab hossain To: Tom Lane Cc: pgsql-general@postgresql.org Sent: Wednesday, Nove

Re: [GENERAL] Postgresql Database Lock Problem

2009-11-18 Thread shohorab hossain
it possible to find from which Application form/window the query is being running. With Thanks & Regards: ----- Shohorab Hossain - Original Message From: Tom Lane To: shohorab hossain Cc: pgsql-general@postgresql.org Sent: Wednesday, November 18, 2009 1:4

Re: [GENERAL] Postgresql Database Lock Problem

2009-11-18 Thread shohorab hossain
quence_istableid_check" CHECK (istableid = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])) "ad_sequence_startnewyear_check" CHECK (startnewyear = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])) Foreign-key constraints: "sequenceclient" FOREIGN KEY (ad_c

[GENERAL] Postgresql Database Lock Problem

2009-11-17 Thread shohorab hossain
e and valuable solution in this regard. I am eagerly looking forward for your quick reply. Thanks in advance: --- Shohorab Hossain Send instant messages to your online friends http://uk.messenger.yahoo.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general