pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgsql: pg_dump: fix mis-dumping of non-global default privileges.
7+ messages / 1 participants
[nested] [flat]

* pgsql: pg_dump: fix mis-dumping of non-global default privileges.
@ 2021-10-22 19:22 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2021-10-22 19:22 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

pg_dump: fix mis-dumping of non-global default privileges.

Non-global default privilege entries should be dumped as-is,
not made relative to the default ACL for their object type.
This would typically only matter if one had revoked some
on-by-default privileges in a global entry, and then wanted
to grant them again in a non-global entry.

Per report from Boris Korzun.  This is an old bug, so back-patch
to all supported branches.

Neil Chen, test case by Masahiko Sawada

Discussion: https://postgr.es/m/111621616618184@mail.yandex.ru
Discussion: https://postgr.es/m/CAA3qoJnr2+1dVJObNtfec=qW4Z0nz=A9+r5bZKoTSy5RDjskMw@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/2acc84c6fd299125702c8a8af13820abcc0d4891

Modified Files
--------------
src/bin/pg_dump/pg_dump.c        | 19 ++++++++++++++++++-
src/bin/pg_dump/t/002_pg_dump.pl | 19 +++++++++++++++++++
2 files changed, 37 insertions(+), 1 deletion(-)



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

* pgsql: pg_dump: fix mis-dumping of non-global default privileges.
@ 2021-10-22 19:22 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2021-10-22 19:22 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

pg_dump: fix mis-dumping of non-global default privileges.

Non-global default privilege entries should be dumped as-is,
not made relative to the default ACL for their object type.
This would typically only matter if one had revoked some
on-by-default privileges in a global entry, and then wanted
to grant them again in a non-global entry.

Per report from Boris Korzun.  This is an old bug, so back-patch
to all supported branches.

Neil Chen, test case by Masahiko Sawada

Discussion: https://postgr.es/m/111621616618184@mail.yandex.ru
Discussion: https://postgr.es/m/CAA3qoJnr2+1dVJObNtfec=qW4Z0nz=A9+r5bZKoTSy5RDjskMw@mail.gmail.com

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/3ad2c2455be0bd42f1ca22907850b93c3afc575b

Modified Files
--------------
src/bin/pg_dump/pg_dump.c        | 19 ++++++++++++++++++-
src/bin/pg_dump/t/002_pg_dump.pl | 19 +++++++++++++++++++
2 files changed, 37 insertions(+), 1 deletion(-)



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

* pgsql: pg_dump: fix mis-dumping of non-global default privileges.
@ 2021-10-22 19:22 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2021-10-22 19:22 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

pg_dump: fix mis-dumping of non-global default privileges.

Non-global default privilege entries should be dumped as-is,
not made relative to the default ACL for their object type.
This would typically only matter if one had revoked some
on-by-default privileges in a global entry, and then wanted
to grant them again in a non-global entry.

Per report from Boris Korzun.  This is an old bug, so back-patch
to all supported branches.

Neil Chen, test case by Masahiko Sawada

Discussion: https://postgr.es/m/111621616618184@mail.yandex.ru
Discussion: https://postgr.es/m/CAA3qoJnr2+1dVJObNtfec=qW4Z0nz=A9+r5bZKoTSy5RDjskMw@mail.gmail.com

Branch
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/476006023538730d2291125b883bfe07d03f3dfa

Modified Files
--------------
src/bin/pg_dump/pg_dump.c        | 19 ++++++++++++++++++-
src/bin/pg_dump/t/002_pg_dump.pl | 19 +++++++++++++++++++
2 files changed, 37 insertions(+), 1 deletion(-)



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

* pgsql: pg_dump: fix mis-dumping of non-global default privileges.
@ 2021-10-22 19:22 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2021-10-22 19:22 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

pg_dump: fix mis-dumping of non-global default privileges.

Non-global default privilege entries should be dumped as-is,
not made relative to the default ACL for their object type.
This would typically only matter if one had revoked some
on-by-default privileges in a global entry, and then wanted
to grant them again in a non-global entry.

Per report from Boris Korzun.  This is an old bug, so back-patch
to all supported branches.

Neil Chen, test case by Masahiko Sawada

Discussion: https://postgr.es/m/111621616618184@mail.yandex.ru
Discussion: https://postgr.es/m/CAA3qoJnr2+1dVJObNtfec=qW4Z0nz=A9+r5bZKoTSy5RDjskMw@mail.gmail.com

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/52b927a731e531005c9fb9f895390a66d75cddb7

Modified Files
--------------
src/bin/pg_dump/pg_dump.c        | 19 ++++++++++++++++++-
src/bin/pg_dump/t/002_pg_dump.pl | 19 +++++++++++++++++++
2 files changed, 37 insertions(+), 1 deletion(-)



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

* pgsql: pg_dump: fix mis-dumping of non-global default privileges.
@ 2021-10-22 19:22 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2021-10-22 19:22 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

pg_dump: fix mis-dumping of non-global default privileges.

Non-global default privilege entries should be dumped as-is,
not made relative to the default ACL for their object type.
This would typically only matter if one had revoked some
on-by-default privileges in a global entry, and then wanted
to grant them again in a non-global entry.

Per report from Boris Korzun.  This is an old bug, so back-patch
to all supported branches.

Neil Chen, test case by Masahiko Sawada

Discussion: https://postgr.es/m/111621616618184@mail.yandex.ru
Discussion: https://postgr.es/m/CAA3qoJnr2+1dVJObNtfec=qW4Z0nz=A9+r5bZKoTSy5RDjskMw@mail.gmail.com

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/871dfe4b7270aa33d0ed8c05abd59d3c2653bd1e

Modified Files
--------------
src/bin/pg_dump/pg_dump.c        | 19 ++++++++++++++++++-
src/bin/pg_dump/t/002_pg_dump.pl | 19 +++++++++++++++++++
2 files changed, 37 insertions(+), 1 deletion(-)



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

* pgsql: pg_dump: fix mis-dumping of non-global default privileges.
@ 2021-10-22 19:22 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2021-10-22 19:22 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

pg_dump: fix mis-dumping of non-global default privileges.

Non-global default privilege entries should be dumped as-is,
not made relative to the default ACL for their object type.
This would typically only matter if one had revoked some
on-by-default privileges in a global entry, and then wanted
to grant them again in a non-global entry.

Per report from Boris Korzun.  This is an old bug, so back-patch
to all supported branches.

Neil Chen, test case by Masahiko Sawada

Discussion: https://postgr.es/m/111621616618184@mail.yandex.ru
Discussion: https://postgr.es/m/CAA3qoJnr2+1dVJObNtfec=qW4Z0nz=A9+r5bZKoTSy5RDjskMw@mail.gmail.com

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/10f9faf6d87393e3599e6892576d902d4ea07143

Modified Files
--------------
src/bin/pg_dump/pg_dump.c        | 19 ++++++++++++++++++-
src/bin/pg_dump/t/002_pg_dump.pl | 40 ++++++++++++++++++++++++++++++++++++++++
2 files changed, 58 insertions(+), 1 deletion(-)



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

* pgsql: pg_dump: fix mis-dumping of non-global default privileges.
@ 2021-10-22 19:22 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2021-10-22 19:22 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

pg_dump: fix mis-dumping of non-global default privileges.

Non-global default privilege entries should be dumped as-is,
not made relative to the default ACL for their object type.
This would typically only matter if one had revoked some
on-by-default privileges in a global entry, and then wanted
to grant them again in a non-global entry.

Per report from Boris Korzun.  This is an old bug, so back-patch
to all supported branches.

Neil Chen, test case by Masahiko Sawada

Discussion: https://postgr.es/m/111621616618184@mail.yandex.ru
Discussion: https://postgr.es/m/CAA3qoJnr2+1dVJObNtfec=qW4Z0nz=A9+r5bZKoTSy5RDjskMw@mail.gmail.com

Branch
------
REL9_6_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/b1df061f704bcb182d3b71cf9d25b9ef07202396

Modified Files
--------------
src/bin/pg_dump/pg_dump.c        | 19 ++++++++++++++++++-
src/bin/pg_dump/t/002_pg_dump.pl | 34 ++++++++++++++++++++++++++++++++++
2 files changed, 52 insertions(+), 1 deletion(-)



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


end of thread, other threads:[~2021-10-22 19:22 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-10-22 19:22 pgsql: pg_dump: fix mis-dumping of non-global default privileges. Tom Lane <tgl@sss.pgh.pa.us>
2021-10-22 19:22 pgsql: pg_dump: fix mis-dumping of non-global default privileges. Tom Lane <tgl@sss.pgh.pa.us>
2021-10-22 19:22 pgsql: pg_dump: fix mis-dumping of non-global default privileges. Tom Lane <tgl@sss.pgh.pa.us>
2021-10-22 19:22 pgsql: pg_dump: fix mis-dumping of non-global default privileges. Tom Lane <tgl@sss.pgh.pa.us>
2021-10-22 19:22 pgsql: pg_dump: fix mis-dumping of non-global default privileges. Tom Lane <tgl@sss.pgh.pa.us>
2021-10-22 19:22 pgsql: pg_dump: fix mis-dumping of non-global default privileges. Tom Lane <tgl@sss.pgh.pa.us>
2021-10-22 19:22 pgsql: pg_dump: fix mis-dumping of non-global default privileges. Tom Lane <tgl@sss.pgh.pa.us>

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