On Tue, May 27, 2025 at 10:12 AM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Tue, May 27, 2025 at 7:02 AM Edwin UY <edwin.uy@xxxxxxxxx> wrote:Will I have to redo the grants?If you use "alter table set schema" the table OID will not change and the grants should follow it. Users would be subject to whatever new permissions apply to the newly created schema rather than the public schema though.
And he'll either have to SET SEARCH_PATH or manually qualify every CREATE TABLE statement with the correct schema name.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
