[HACKERS] What is the current status of FOR UPDATE cursors ?

2012-05-06 Thread Hannu Krosing
What is the current status of FOR UPDATE cursors ? older docs claim that the syntax is supported, but gives an error http://www.postgresql.org/docs/8.2/static/sql-declare.html docs for 9.1 do not have FOR UPDATE in main section http://www.postgresql.org/docs/9.1/static/sql-declare.html but the

[HACKERS] more possible dead ports cleanup

2012-05-06 Thread Peter Eisentraut
I think a few more things could removed/simplified after the recent round of port removal: - Remove definition of offsetof() in c.h - (Side point, the definition of endof() in the same place isn't used anywhere, and doesn't look safe to me, because it can go one past the end of memory.) - Remove

Re: [HACKERS] remove dead ports?

2012-05-06 Thread Tom Lane
Peter Geoghegan writes: > On 6 May 2012 01:06, Robert Haas wrote: >> I think we should err on the side of removing less rather than more. >> It won't hurt anything much to leave these around for another few >> years. > I think it's better to force users of platforms like IRIX and BSD/OS, > platf

Re: [HACKERS] What is the current status of FOR UPDATE cursors ?

2012-05-06 Thread Tom Lane
Hannu Krosing writes: > What is the current status of FOR UPDATE cursors ? Same as it's been for a long time: FOR UPDATE [ OF table_name ] works fine. > older docs claim that the syntax is supported, but gives an error > http://www.postgresql.org/docs/8.2/static/sql-declare.html Old docs incorr

Re: [HACKERS] What is the current status of FOR UPDATE cursors ?

2012-05-06 Thread Hannu Krosing
On Sun, 2012-05-06 at 13:17 -0400, Tom Lane wrote: > Hannu Krosing writes: > > What is the current status of FOR UPDATE cursors ? > > Same as it's been for a long time: FOR UPDATE [ OF table_name ] > works fine. Ok, then it is just documentation fix currently it is missing from \h declare and d