Brian Hayden

`CREATE SCHEMA IF NOT EXISTS ...` *does* throw an error if the Postgres user doesn't have sufficient GRANTs to create a schema in that database. Grants get checked before the...

We would like to migrate various databases from Oracle to Postgres. In our organization, only DBAs can create schemas (for compliance reasons; we work with sensitive data and there are...

I'm curious why you "prefer" the current behavior? I don't see that it has any advantages, and it seems just wrong to me. If there's a config option called `CREATE_SCHEMA`,...