From: | Erik Wienhold <ewie(at)ewie(dot)name> |
---|---|
To: | Michael Corey <michael(dot)corey(dot)ap(at)nielsen(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Changed functionality from 14.3 to 15.3 |
Date: | 2023-09-20 16:33:48 |
Message-ID: | uygeqa33gw6qmd3sz5n2pxangrrl4z5mixxevbyjhr7tsyjvlg@hc4hryl4numv |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2023-09-20 09:15 -0400, Michael Corey wrote:
> Thanks for responding. 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.
And both databases start empty or at least in the exact same state?
> 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.
I don't know why those privileges could be missing if that script
completes. Please provide the privileges like I asked to see what's
actually granted on both databases:
> On Tue, Sep 19, 2023 at 8:17 PM Erik Wienhold <ewie(at)ewie(dot)name> wrote:
> >
> > Have you checked that the permissions are actually the same on both
> > databases after running that script?
> >
> > \dn+ ref_schema|sten_schema
> > \dp ref_schema.ref_media_code
> > \dp sten_schema.sten_media_codes_view
--
Erik
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Corey | 2023-09-20 17:17:41 | Re: Changed functionality from 14.3 to 15.3 |
Previous Message | Alvaro Herrera | 2023-09-20 15:20:49 | Re: Calculating Days/Time(Are Loops Neccessary?) |