Re: updatable cursors and ORDER BY

On Wed, May 9, 2018 at 7:43 PM, Peter Eisentraut < peter.eisentr...@2ndquadrant.com> wrote: > The DECLARE reference page says: > > """ > Another reason to use FOR UPDATE is that without it, a subsequent WHERE > CURRENT OF might fail if the cursor query does not meet the SQL > standard's rules for

Re: updatable cursors and ORDER BY

Peter Eisentraut writes: > The DECLARE reference page says: > """ > Another reason to use FOR UPDATE is that without it, a subsequent WHERE > CURRENT OF might fail if the cursor query does not meet the SQL > standard's rules for being “simply updatable” (in particular, the cursor > must reference

updatable cursors and ORDER BY

The DECLARE reference page says: """ Another reason to use FOR UPDATE is that without it, a subsequent WHERE CURRENT OF might fail if the cursor query does not meet the SQL standard's rules for being “simply updatable” (in particular, the cursor must reference just one table and not use grouping o

Re: Mistakes between an example and its description

El 09/05/18 a las 18:52, PG Doc comments form escribió: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/9.6/static/sql-createindex.html > Description: > > In Postgres Doc: Index > page(https://www.postgresql.org/docs/9.6/static/sql-c

Mistakes between an example and its description

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/sql-createindex.html Description: In Postgres Doc: Index page(https://www.postgresql.org/docs/9.6/static/sql-createindex.html), there is an mismatch between an example description

\i and \ir separated by \if now...

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/app-psql.html Description: While I get that we want alphabetical order an exception for \i and \ir seems warranted; or maybe make \ir part of the \i meta command description - \i[r]

RLS does not itself expand to views, unless you set a right owner - worth mentioning?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.5/static/ddl-rowsecurity.html Description: Hi, Do you think that maybe https://www.postgresql.org/docs/9.5/static/ddl-rowsecurity.html should mention the RLS does not itself expand to view