agora inbox for pgsql-committers@postgresql.org  
help / color / mirror / Atom feed
pgsql: Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE
6+ messages / 1 participants
[nested] [flat]

* pgsql: Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE
@ 2026-08-10 13:41 Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Noah Misch @ 2026-08-10 13:41 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE.

This omission allowed roles without USAGE on a type to create range
types that depend on it, which could prevent the owner from
changing the type later.

Reported-by: Jingzhou Fu <fuboat@outlook.com>
Author: Nathan Bossart <nathandbossart@gmail.com>
Reviewed-by: Noah Misch <noah@leadboat.com>
Reviewed-by: Robert Haas <robertmhaas@gmail.com>
Security: CVE-2026-6470
Backpatch-through: 14

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/a9f6e768ac281aa1adba58d3e9c7c2b4e9474ec2
Author: Nathan Bossart <nathan@postgresql.org>

Modified Files
--------------
doc/src/sgml/ref/create_type.sgml        |  5 +++++
src/backend/commands/typecmds.c          |  4 ++++
src/test/regress/expected/rangetypes.out | 15 +++++++++++++++
src/test/regress/sql/rangetypes.sql      | 14 ++++++++++++++
4 files changed, 38 insertions(+)



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* pgsql: Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE
@ 2026-08-10 13:41 Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Noah Misch @ 2026-08-10 13:41 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE.

This omission allowed roles without USAGE on a type to create range
types that depend on it, which could prevent the owner from
changing the type later.

Reported-by: Jingzhou Fu <fuboat@outlook.com>
Author: Nathan Bossart <nathandbossart@gmail.com>
Reviewed-by: Noah Misch <noah@leadboat.com>
Reviewed-by: Robert Haas <robertmhaas@gmail.com>
Security: CVE-2026-6470
Backpatch-through: 14

Branch
------
REL_19_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/efdb260728c93f605f9ef7aaef56b013f6bb87b7
Author: Nathan Bossart <nathan@postgresql.org>

Modified Files
--------------
doc/src/sgml/ref/create_type.sgml        |  5 +++++
src/backend/commands/typecmds.c          |  4 ++++
src/test/regress/expected/rangetypes.out | 15 +++++++++++++++
src/test/regress/sql/rangetypes.sql      | 14 ++++++++++++++
4 files changed, 38 insertions(+)



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* pgsql: Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE
@ 2026-08-10 13:41 Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Noah Misch @ 2026-08-10 13:41 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE.

This omission allowed roles without USAGE on a type to create range
types that depend on it, which could prevent the owner from
changing the type later.

Reported-by: Jingzhou Fu <fuboat@outlook.com>
Author: Nathan Bossart <nathandbossart@gmail.com>
Reviewed-by: Noah Misch <noah@leadboat.com>
Reviewed-by: Robert Haas <robertmhaas@gmail.com>
Security: CVE-2026-6470
Backpatch-through: 14

Branch
------
REL_18_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/2e91f8548daa7c7c7d5848f3812fac95fe9e9db5
Author: Nathan Bossart <nathan@postgresql.org>

Modified Files
--------------
doc/src/sgml/ref/create_type.sgml        |  5 +++++
src/backend/commands/typecmds.c          |  4 ++++
src/test/regress/expected/rangetypes.out | 15 +++++++++++++++
src/test/regress/sql/rangetypes.sql      | 14 ++++++++++++++
4 files changed, 38 insertions(+)



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* pgsql: Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE
@ 2026-08-10 13:41 Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Noah Misch @ 2026-08-10 13:41 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE.

This omission allowed roles without USAGE on a type to create range
types that depend on it, which could prevent the owner from
changing the type later.

Reported-by: Jingzhou Fu <fuboat@outlook.com>
Author: Nathan Bossart <nathandbossart@gmail.com>
Reviewed-by: Noah Misch <noah@leadboat.com>
Reviewed-by: Robert Haas <robertmhaas@gmail.com>
Security: CVE-2026-6470
Backpatch-through: 14

Branch
------
REL_17_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/fd6d3e7e9d5554bd11623d11445d82c7293e36e2
Author: Nathan Bossart <nathan@postgresql.org>

Modified Files
--------------
doc/src/sgml/ref/create_type.sgml        |  5 +++++
src/backend/commands/typecmds.c          |  4 ++++
src/test/regress/expected/rangetypes.out | 15 +++++++++++++++
src/test/regress/sql/rangetypes.sql      | 14 ++++++++++++++
4 files changed, 38 insertions(+)



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* pgsql: Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE
@ 2026-08-10 13:41 Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Noah Misch @ 2026-08-10 13:41 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE.

This omission allowed roles without USAGE on a type to create range
types that depend on it, which could prevent the owner from
changing the type later.

Reported-by: Jingzhou Fu <fuboat@outlook.com>
Author: Nathan Bossart <nathandbossart@gmail.com>
Reviewed-by: Noah Misch <noah@leadboat.com>
Reviewed-by: Robert Haas <robertmhaas@gmail.com>
Security: CVE-2026-6470
Backpatch-through: 14

Branch
------
REL_16_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/24855357c32faa0acfdc9da0a229d969d79ae124
Author: Nathan Bossart <nathan@postgresql.org>

Modified Files
--------------
doc/src/sgml/ref/create_type.sgml        |  5 +++++
src/backend/commands/typecmds.c          |  4 ++++
src/test/regress/expected/rangetypes.out | 15 +++++++++++++++
src/test/regress/sql/rangetypes.sql      | 14 ++++++++++++++
4 files changed, 38 insertions(+)



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* pgsql: Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE
@ 2026-08-10 13:41 Noah Misch <noah@leadboat.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Noah Misch @ 2026-08-10 13:41 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE.

This omission allowed roles without USAGE on a type to create range
types that depend on it, which could prevent the owner from
changing the type later.

Reported-by: Jingzhou Fu <fuboat@outlook.com>
Author: Nathan Bossart <nathandbossart@gmail.com>
Reviewed-by: Noah Misch <noah@leadboat.com>
Reviewed-by: Robert Haas <robertmhaas@gmail.com>
Security: CVE-2026-6470
Backpatch-through: 14

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/97e2774028bdeda9499ec7bb8f15e706b17fd1c8
Author: Nathan Bossart <nathan@postgresql.org>

Modified Files
--------------
doc/src/sgml/ref/create_type.sgml        |  5 +++++
src/backend/commands/typecmds.c          |  4 ++++
src/test/regress/expected/rangetypes.out | 15 +++++++++++++++
src/test/regress/sql/rangetypes.sql      | 14 ++++++++++++++
4 files changed, 38 insertions(+)



^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2026-08-10 13:41 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-08-10 13:41 pgsql: Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE Noah Misch <noah@leadboat.com>
2026-08-10 13:41 pgsql: Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE Noah Misch <noah@leadboat.com>
2026-08-10 13:41 pgsql: Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE Noah Misch <noah@leadboat.com>
2026-08-10 13:41 pgsql: Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE Noah Misch <noah@leadboat.com>
2026-08-10 13:41 pgsql: Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE Noah Misch <noah@leadboat.com>
2026-08-10 13:41 pgsql: Check for USAGE privilege on the subtype in CREATE TYPE AS RANGE Noah Misch <noah@leadboat.com>

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