public inbox for [email protected]help / color / mirror / Atom feed
pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON 6+ messages / 1 participants [nested] [flat]
* pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON @ 2026-02-11 10:56 Dean Rasheed <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Dean Rasheed @ 2026-02-11 10:56 UTC (permalink / raw) To: [email protected] doc: Mention all SELECT privileges required by INSERT ... ON CONFLICT. On the INSERT page, mention that SELECT privileges are also required for any columns mentioned in the arbiter clause, including those referred to by the constraint, and clarify that this applies to all forms of ON CONFLICT, not just ON CONFLICT DO UPDATE. Author: Dean Rasheed <[email protected]> Reviewed-by: Viktor Holmberg <[email protected]> Discussion: https://postgr.es/m/CAEZATCXGwMQ+x00YY9XYG46T0kCajH=21QaYL9Xatz0dLKii+g@mail.gmail.com Backpatch-through: 14 Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/3586c5e7899732ad16f9d3bada11de940db5ecd7 Modified Files -------------- doc/src/sgml/ref/insert.sgml | 11 +++++++---- 1 file changed, 7 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON @ 2026-02-11 10:56 Dean Rasheed <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Dean Rasheed @ 2026-02-11 10:56 UTC (permalink / raw) To: [email protected] doc: Mention all SELECT privileges required by INSERT ... ON CONFLICT. On the INSERT page, mention that SELECT privileges are also required for any columns mentioned in the arbiter clause, including those referred to by the constraint, and clarify that this applies to all forms of ON CONFLICT, not just ON CONFLICT DO UPDATE. Author: Dean Rasheed <[email protected]> Reviewed-by: Viktor Holmberg <[email protected]> Discussion: https://postgr.es/m/CAEZATCXGwMQ+x00YY9XYG46T0kCajH=21QaYL9Xatz0dLKii+g@mail.gmail.com Backpatch-through: 14 Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/51a0d766b34f1001daf3789cf2f6d1f991088394 Modified Files -------------- doc/src/sgml/ref/insert.sgml | 11 +++++++---- 1 file changed, 7 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON @ 2026-02-11 10:56 Dean Rasheed <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Dean Rasheed @ 2026-02-11 10:56 UTC (permalink / raw) To: [email protected] doc: Mention all SELECT privileges required by INSERT ... ON CONFLICT. On the INSERT page, mention that SELECT privileges are also required for any columns mentioned in the arbiter clause, including those referred to by the constraint, and clarify that this applies to all forms of ON CONFLICT, not just ON CONFLICT DO UPDATE. Author: Dean Rasheed <[email protected]> Reviewed-by: Viktor Holmberg <[email protected]> Discussion: https://postgr.es/m/CAEZATCXGwMQ+x00YY9XYG46T0kCajH=21QaYL9Xatz0dLKii+g@mail.gmail.com Backpatch-through: 14 Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/cfd790159d5e2301b3534c8d63d75e904d050f6b Modified Files -------------- doc/src/sgml/ref/insert.sgml | 11 +++++++---- 1 file changed, 7 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON @ 2026-02-11 10:56 Dean Rasheed <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Dean Rasheed @ 2026-02-11 10:56 UTC (permalink / raw) To: [email protected] doc: Mention all SELECT privileges required by INSERT ... ON CONFLICT. On the INSERT page, mention that SELECT privileges are also required for any columns mentioned in the arbiter clause, including those referred to by the constraint, and clarify that this applies to all forms of ON CONFLICT, not just ON CONFLICT DO UPDATE. Author: Dean Rasheed <[email protected]> Reviewed-by: Viktor Holmberg <[email protected]> Discussion: https://postgr.es/m/CAEZATCXGwMQ+x00YY9XYG46T0kCajH=21QaYL9Xatz0dLKii+g@mail.gmail.com Backpatch-through: 14 Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/7233e70537da6a9e6f1f383c3a2bed73fc121b62 Modified Files -------------- doc/src/sgml/ref/insert.sgml | 11 +++++++---- 1 file changed, 7 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON @ 2026-02-11 10:56 Dean Rasheed <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Dean Rasheed @ 2026-02-11 10:56 UTC (permalink / raw) To: [email protected] doc: Mention all SELECT privileges required by INSERT ... ON CONFLICT. On the INSERT page, mention that SELECT privileges are also required for any columns mentioned in the arbiter clause, including those referred to by the constraint, and clarify that this applies to all forms of ON CONFLICT, not just ON CONFLICT DO UPDATE. Author: Dean Rasheed <[email protected]> Reviewed-by: Viktor Holmberg <[email protected]> Discussion: https://postgr.es/m/CAEZATCXGwMQ+x00YY9XYG46T0kCajH=21QaYL9Xatz0dLKii+g@mail.gmail.com Backpatch-through: 14 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/bc953bf52314ca881a18703f86b68743ef6f3a32 Modified Files -------------- doc/src/sgml/ref/insert.sgml | 11 +++++++---- 1 file changed, 7 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON @ 2026-02-11 10:56 Dean Rasheed <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Dean Rasheed @ 2026-02-11 10:56 UTC (permalink / raw) To: [email protected] doc: Mention all SELECT privileges required by INSERT ... ON CONFLICT. On the INSERT page, mention that SELECT privileges are also required for any columns mentioned in the arbiter clause, including those referred to by the constraint, and clarify that this applies to all forms of ON CONFLICT, not just ON CONFLICT DO UPDATE. Author: Dean Rasheed <[email protected]> Reviewed-by: Viktor Holmberg <[email protected]> Discussion: https://postgr.es/m/CAEZATCXGwMQ+x00YY9XYG46T0kCajH=21QaYL9Xatz0dLKii+g@mail.gmail.com Backpatch-through: 14 Branch ------ REL_17_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/0f7ca0d7dc97ecb50ac964aa50c4fcd9a5735556 Modified Files -------------- doc/src/sgml/ref/insert.sgml | 11 +++++++---- 1 file changed, 7 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2026-02-11 10:56 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-02-11 10:56 pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON Dean Rasheed <[email protected]> 2026-02-11 10:56 pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON Dean Rasheed <[email protected]> 2026-02-11 10:56 pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON Dean Rasheed <[email protected]> 2026-02-11 10:56 pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON Dean Rasheed <[email protected]> 2026-02-11 10:56 pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON Dean Rasheed <[email protected]> 2026-02-11 10:56 pgsql: doc: Mention all SELECT privileges required by INSERT ... ON CON Dean Rasheed <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox