pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: SELECT ... FOR UPDATE OF clause documentation implies use of table_names rather than aliases
Date: Thu, 7 Dec 2023 19:43:17 -0500
Message-ID: <ZXJmpe__WfBZgKX2@momjian.us> (raw)
In-Reply-To: <CAKFQuwYVRJg9mdCSVKCdSpEoWnje9jxEiFfvOsX3Kr+_uG2NbA@mail.gmail.com>
References: <152483686904.19805.3369061025704720797@wrigleys.postgresql.org>
	<ZVflgb-C2xAmdgBC@momjian.us>
	<CAKFQuwa9CX11j5AZSp0Hk16wwW7474hhWHsCEGg1-dMsa4Mg+g@mail.gmail.com>
	<ZVwQHCA85qhKPUcG@momjian.us>
	<CAKFQuwb=PnpzD=k7wWyWNdE2NnExw0kLpYcpOOC4P_EHdC8Wtw@mail.gmail.com>
	<ZVwg9AP4Zvj3RR1J@momjian.us>
	<CAKFQuwYVRJg9mdCSVKCdSpEoWnje9jxEiFfvOsX3Kr+_uG2NbA@mail.gmail.com>

On Mon, Nov 20, 2023 at 08:20:57PM -0700, David G. Johnston wrote:
> On Mon, Nov 20, 2023 at 8:16 PM Bruce Momjian <bruce@momjian.us> wrote:
> 
>     On Mon, Nov 20, 2023 at 07:19:39PM -0700, David G. Johnston wrote:
>     > The placement in the numbered listing section feels wrong, I am OK with
>     > the wording.  It should be down in the clause details.
>     >
>     > FOR lock_strength [ OF from_reference [, ...] ] [ NOWAIT | SKIP LOCKED ] 
>     --
>     > need to change this spot to match
>     >
>     > where lock_strength can be one of
>     >
>     > [...]
>     >
>     > + and from_reference must be a table alias or non-hidden table_name
>     referenced
>     > in the FROM clause.
>     >
>     > For more information on each [...]
> 
>     Ah, good point.  I was searching for "FOR UPDATE" so I missed that
>     section;  updated patch attached.
> 
> 
> 
> WFM.

Patch applied to master.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.





view thread (8+ messages)

Message-ID: <ZXJmpe__WfBZgKX2@momjian.us>
Permalink:  ../ZXJmpe__WfBZgKX2@momjian.us/
Also on:    postgresql.org/message-id/ZXJmpe__WfBZgKX2@momjian.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: bruce@momjian.us, david.g.johnston@gmail.com, pgsql-docs@lists.postgresql.org
  Subject: Re: SELECT ... FOR UPDATE OF clause documentation implies use of table_names rather than aliases
  In-Reply-To: <ZXJmpe__WfBZgKX2@momjian.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox