Re: Changed functionality from 14.3 to 15.3 - Mailing list pgsql-general

From Imre Samu
Subject Re: Changed functionality from 14.3 to 15.3
Date
Msg-id CAJnEWwkzd+uRsbbTdRMyeXRiBAW=M9GS8EmXyzzr2RagNgcK6w@mail.gmail.com
Whole thread Raw
In response to Re: Changed functionality from 14.3 to 15.3  (Michael Corey <michael.corey.ap@nielsen.com>)
List pgsql-general
Michael Corey <michael.corey.ap@nielsen.com> ezt írta (időpont: 2023. szept. 20., Sze, 20:48):
... All of the DDL is just the setup for the test case.  I ran those steps in both databases to setup the exact same environment.  The COMMIT is not needed for the test out of habit I put it in my setup.  The main issue is in 14.3 I can run this select as user sten_schema, but in 15.3 I am unable due to a permission issue.

Hi Michael,

I couldn't reproduce the outcome you observed in PG14.3 using the "postgres:14.3" (debian) Docker image. 

My minimal docker test:

docker pull postgres:14.3
docker run --name pg143tx -e POSTGRES_DB=db14 -e POSTGRES_USER=postgres -e POSTGRES_PASSWORD=pw9 -d postgres:14.3
docker exec -ti pg143tx psql -d db14 -U postgres


My log:

psql (14.3 (Debian 14.3-1.pgdg110+1))
Type "help" for help.

....  < copy paste your test code > ....

CREATE ROLE
ERROR:  role "rds_superuser" does not exist
CREATE ROLE
CREATE ROLE
CREATE ROLE
CREATE ROLE
CREATE ROLE
ALTER ROLE
ALTER ROLE
GRANT ROLE
CREATE ROLE
ALTER ROLE
ALTER ROLE
GRANT ROLE
CREATE SCHEMA
ALTER SCHEMA
GRANT
GRANT
GRANT
GRANT
CREATE TABLE
ALTER TABLE
GRANT
GRANT
GRANT
INSERT 0 1
INSERT 0 1
INSERT 0 1
WARNING:  there is no transaction in progress
COMMIT
CREATE SCHEMA
ALTER SCHEMA
GRANT
GRANT
GRANT
GRANT
CREATE VIEW
ALTER TABLE
GRANT
GRANT
db14=# \c db14 sten_schema
You are now connected to database "db14" as user "sten_schema".
db14=> select * from sten_media_codes_view ;
ERROR:  permission denied for table ref_media_code
db14=>  select * from ref_media_code ;
ERROR:  permission denied for table ref_media_code

db14=> SELECT version();
                                                           version                                                          
-----------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 14.3 (Debian 14.3-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
(1 row)

Regards,
  Imre

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order
Next
From: veem v
Date:
Subject: Re: Database selection