pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: pawel.ziewiecki@gmail.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18160: first create table show "ERROR:  permission denied for schema public", next create table works
Date: Wed, 18 Oct 2023 22:15:58 +0200
Message-ID: <4b4ff8f5427479f6160a625f70543b3f76cab4d3.camel@cybertec.at> (raw)
In-Reply-To: <18160-ccc671c5c94fce11@postgresql.org>
References: <18160-ccc671c5c94fce11@postgresql.org>

On Wed, 2023-10-18 at 17:01 +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
> 
> Bug reference:      18160
> Logged by:          Pawel Ziewiecki
> Email address:      pawel.ziewiecki@gmail.com
> PostgreSQL version: 15.3
> Operating system:   aws rds postgresql
> Description:        
> 
> create table (failed) + alter table (table not exist) + create table success
> in public schema (?)
> 
> psql -h database-imenago.cahxcxwmeghl.eu-central-1.rds.amazonaws.com -p 5432
> -U postgres
> Password for user postgres:
> psql (15.4 (Debian 15.4-1.pgdg120+1), server 15.3)
> SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384,
> compression: off)
> Type "help" for help.
> 
> postgres=> create user u1 with createdb password 'u1pwd';
> CREATE ROLE
> postgres=> \c postgres u1
> Password for user u1:
> psql (15.4 (Debian 15.4-1.pgdg120+1), server 15.3)
> SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384,
> compression: off)
> You are now connected to database "postgres" as user "u1".
> postgres=> create database u1db with owner u1;
> CREATE DATABASE
> postgres=> \c u1db
> psql (15.4 (Debian 15.4-1.pgdg120+1), server 15.3)
> SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384,
> compression: off)
> You are now connected to database "u1db" as user "u1".
> u1db=> create table public.t1 (id int);
> ERROR:  permission denied for schema public
> LINE 1: create table public.t1 (id int);
>                      ^
> u1db=> alter table public.t1 owner to u1;
> ERROR:  relation "public.t1" does not exist
> u1db=> create table public.t1 (id int);
> CREATE TABLE
> u1db=> \d
>        List of relations
>  Schema | Name | Type  | Owner
> --------+------+-------+-------
>  public | t1   | table | u1
> (1 row)
> 






view thread (4+ messages)  latest in thread

Message-ID: <4b4ff8f5427479f6160a625f70543b3f76cab4d3.camel@cybertec.at>
Permalink:  ../4b4ff8f5427479f6160a625f70543b3f76cab4d3.camel@cybertec.at/
Also on:    postgresql.org/message-id/4b4ff8f5427479f6160a625f70543b3f76cab4d3.camel@cybertec.at

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: laurenz.albe@cybertec.at, pawel.ziewiecki@gmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #18160: first create table show "ERROR:  permission denied for schema public", next create table works
  In-Reply-To: <4b4ff8f5427479f6160a625f70543b3f76cab4d3.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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