why my delete command blocked....

From: Yi Zhao <yi(dot)zhao(at)alibaba-inc(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: why my delete command blocked....
Date: 2008-09-01 04:05:08
Message-ID: 1220241908.3185.6.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-www

hi, all:
I use a plproxy to execute sql like below:
CREATE OR REPLACE FUNCTION public.dmlexec(query text,op text) RETURNS
setof integer AS $$
CLUSTER 'testcluster';
RUN ON all;
$$ LANGUAGE plproxy;
create or replace function public.dmlExec(query text, op text) returns
integer as $$
declare
ret integer;
begin
execute query;
return 1;
end;
$$ language plpgsql;

when I exectue sql like 'select dmlexec('delete from table_test where
id = 2', 'test') at the same time in numerous process, the delete sql
will blocked.....
so I must select pg_cancel_backend(...).

is there a deadlock??

postgresql version: 8.3.0

thanks all:)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brent Wood 2008-09-01 06:48:34 Re: Oracle and Postgresql
Previous Message David Fetter 2008-09-01 03:44:41 Re: Oracle and Postgresql

Browse pgsql-www by date

  From Date Subject
Next Message Henry 2008-09-01 07:42:58 Re: Oracle and Postgresql
Previous Message David Fetter 2008-09-01 03:44:41 Re: Oracle and Postgresql