út 18. 2. 2020 v 18:27 odesílatel Laurenz Albe <laurenz.a...@cybertec.at> napsal:
> On Mon, 2020-02-17 at 19:41 +0100, Pavel Stehule wrote: > > I tested > > > > CREATE OR REPLACE FUNCTION public.fx(integer) > > RETURNS void > > LANGUAGE plpgsql > > AS $function$ > > begin > > for i in 1..$1 loop > > begin > > insert into foo values(i); > > exception when others then > > raise notice 'yyy'; > > end; > > end loop; > > end; > > $function$ > > > > and I don't see any significant difference between numbers less than 64 > and higher > > Did you have several concurrent sessions accessing the rows that others > created? > no, I didn't Pavel > Yours, > Laurenz Albe > -- > Cybertec | https://www.cybertec-postgresql.com > >
