Can't make tables in public in beta15 PostgreSQL
add tag
depesz 
Hi,
I just noticed that you can't make normal tables in public: https://dbfiddle.uk/?rdbms=postgres_15&fiddle=06580f43fb20dcc9469a77111c9a077f

This is related to https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b073c3ccd06e4cb845e121387a43faa8c68a7b62

Of course I can make my own schema, and make tables in it, but perhaps it would be possible to make the fiddle user owner of the db? or explicitly grant them the privileges to create objects in public?
Top Answer
Jack Douglas 
I've made the fiddle user owner of the public schema so this works now.

Thanks for pointing this out, I read [your post](https://www.depesz.com/2021/09/10/waiting-for-postgresql-15-revoke-public-create-from-public-schema-now-owned-by-pg_database_owner/) about it last year but forgot it. A very sensible change in my opinion.
comments
transcript

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.