Re: What is the current status of FOR UPDATE cursors ?
От | Hannu Krosing |
---|---|
Тема | Re: What is the current status of FOR UPDATE cursors ? |
Дата | |
Msg-id | 1336337754.19151.244.camel@hvost обсуждение исходный текст |
Ответ на | Re: What is the current status of FOR UPDATE cursors ? (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: What is the current status of FOR UPDATE cursors ?
|
Список | pgsql-hackers |
On Sun, 2012-05-06 at 13:17 -0400, Tom Lane wrote: > Hannu Krosing <hannu@2ndQuadrant.com> 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 docs hannu@hvost:~/work/pg92$ TESTINST/bin/psql -p 9200 -h /tmp psql (9.2devel) Type "help" for help. hannu=# \h declare Command: DECLARE Description: define a cursor Syntax: DECLARE name [ BINARY ] [ INSENSITIVE ] [ [ NO ] SCROLL ] CURSOR [ { WITH | WITHOUT } HOLD ] FOR query hannu=# > > 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 incorrectly said that it was FOR UPDATE [ OF column_name ] > but we have never implemented it that way. > > regards, tom lane >
В списке pgsql-hackers по дате отправления: