How can I set a timeout for a locked table in Function ?

From: İlyas Derse <ilyasderse(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: How can I set a timeout for a locked table in Function ?
Date: 2020-01-03 09:53:50
Message-ID: CALcdmySuZO9OsFOC6-7gPN4PfmLe1W2y_pmxPfjMthWAH-qYNA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

CREATE OR REPLACE FUNCTION public."testlock"()
RETURNS TABLE
(
id integer,
name character varying,
state integer,
owner character varying
)
LANGUAGE 'plpgsql'
AS $BODY$
BEGIN
SET "statement_timeout" = 6000; --- It's not changing. !!
LOCK TABLE public."lock" IN ROW EXCLUSIVE MODE;
UPDATE public."lock" as l set name = 'deneme' WHERE l."id" = 4;

RETURN QUERY
select l."id",l."name",l."state",l."owner" from public."lock" as l,
pg_sleep(10) where l."id" = 4;
END;
$BODY$;

select * from public."testlock"();

How can I do ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick FICHE 2020-01-03 13:04:07 RE: How can I set a timeout for a locked table in Function ?
Previous Message Adrian Klaver 2020-01-02 17:10:12 Re: Schema dump