Thread: [DOCS] Mistype

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/sql-createpolicy.html
Description:

"Note that INSERT with ON CONFLICT DO UPDATE checks INSERT policies' WITH
CHECK expressions only for rows appended to the relation by the INSERT
path."

May be "by the INSERT part"?

On 8/27/17 05:30, splarv@ya.ru wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.6/static/sql-createpolicy.html
> Description:
>
> "Note that INSERT with ON CONFLICT DO UPDATE checks INSERT policies' WITH
> CHECK expressions only for rows appended to the relation by the INSERT
> path."
>
> May be "by the INSERT part"?

No this is correct.

The ON CONFLICT documentation frequently speaks of an "UPDATE path" and
an "INSERT path" that the command may end up taking.

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services