Full bug list

Hi Andy,

Thats the reason which techdocs.postgresql.org started for, but since it's
grown to encompass so many things, that section hasn't been updated in ages.
:-(

Perhaps its time to look at a better way of keeping it updated?

:-)

Regards and best wishes,

Justin Clift

Hi!

My base contains a table objectid

create table objectid(
next bigint
);

INSERT INTO objectid values(1);

I do really need to use this table like if it was a sequence so I made
some pl/pgsql functions ( functions at the end of the mail ).
But when I run them in three psql at the same time the results are
weird... Here are the results :

psql1: 2 ( ok )
psql2: 1 ( instead of 3 )
psql3: 1 ( instead of 4 )

Scary...

and after that, a "select * from objectid;" returns 4 ( that's ok ).

I'm using pgsql 7.1.3 ( debian package 7.1.3-8 on a 2.4.17 kernel )

-----------------------------
----------- Functions
-----------------------------

drop table objectid;

create table objectid(
next bigint
);

INSERT INTO objectid values(1);

drop function next_objectid();

create function next_objectid() returns bigint as '
DECLARE
o RECORD;
a integer;
BEGIN
raise notice ''before lock'';
lock table objectid in access exclusive mode;
raise notice ''locked, before pause'';
a := pause(1000000);
raise notice ''pause finished, updating'';
update objectid set next=next+1;
select into o next from objectid;
raise notice ''returning'';
return o.next;
END;
' language 'plpgsql';

drop function pause(int);

create function pause(int) returns int as '
DECLARE
i integer;
j integer;
BEGIN
FOR i IN 1 .. $1 LOOP
j := i+1;
end loop;
return j;
END;
' language 'plpgsql';

It would be useful to be able to search a list of known bugs for
the version of postgresql that you're running. Upgrading to the
latest version to see if it sorts out a problem isn't always a
sensible option..
Andy
----- Original Message -----
From: "Justin" <aa2@bigpond.net.au>
To: "Andy Marden" <amarden@usa.net>; <pgsql-bugs@postgresql.org>
Sent: Friday, February 22, 2002 3:24 AM
Subject: Re: Full bug list

Hi Andy,

Thats the reason which techdocs.postgresql.org started for,

but since it's

grown to encompass so many things, that section hasn't been

updated in ages.

:-(

Perhaps its time to look at a better way of keeping it

updated?

:-)

Regards and best wishes,

Justin Clift

On Thursday 21 February 2002 20:32, Andy Marden wrote:

Is there a repository on the web somewhere of all the bugs

found, versions

they are found against and what theire status is?

---------------------------(end of

broadcast)---------------------------

TIP 2: you can get off all lists at once with the unregister

command

(send "unregister YourEmailAddressHere" to

majordomo@postgresql.org)

Olivier Garcia <ogarcia@waidan.com> writes:

[ can't re-implement nextval() in plpgsql ]

The problem is that plpgsql doesn't do SetQuerySnapshot between
statements of a function, so although your different invocations are
forced to wait for each other by the LOCK statements, they cannot see
each other's effects on the objectid table. (Each one sees the others
as transactions that hadn't committed when it started, so it ignores
their effects per MVCC rules.)

Whether this is a bug, and if so what correct behavior ought to be,
has been the subject of some dispute for awhile --- try searching in
the pghackers archives for "CommandCounterIncrement" and
"SetQuerySnapshot". Nothing's been decided yet.

Although you could get the behavior you want by issuing the commands
separately (not bundled in a plpgsql function), I rather wonder why
you are going to all this effort. Why not just use a sequence?

regards, tom lane

Hi Andy,

I agree with you totally.

Don't yet know how to implement it, and don't have much spare time to do so
yet either. I'm working on some stuff which will mean there are more people
to help with the techdocs site and get things done (if it works), therefore
improving the present techdocs system of showing known bugs and fixes, etc.

But it's going to take a few months of effort.

:-)

Regards and best wishes,

Justin Clift