Revoking public schema access not working as expected

[SharpEdgeMarshall]

Like this issue on terraform when you create a schema and explicitly set a SchemaPolicy for PUBLIC role it's ignored and PUBLIC role has Create and Usage permissions

Example code

pulumi_postgresql.Schema("schema",
        name="public",
        database=db.name,
        owner=role.name,
        policies=[
            # PUBLIC role
            pgsql.outputs.SchemaPolicy(
                create=False,
                usage=False,
            )
        ],
        opts=default_resource_opt
    )

[justinvp]

Thanks for pointing this out and linking to the underlying TF issue. We'll keep this open to track on our side.