Bug in handling of schema names containing non-standard characters

[emarsden]

A schema name containing a non-standard character such as "." can be created, but it cannot then be used as a schema qualifier when creating a table.

pgeltestdb:main=> CREATE schema "my.test";
CREATE SCHEMA
pgeltestdb:main=> CREATE TABLE "my.test".foobles(a INTEGER);
ERROR:  invalid name syntax
CONTEXTE : SQL statement "SELECT COUNT(*)
            FROM pg_class C
            WHERE C.relnamespace = r_schema_name::regnamespace::oid"
PL/pgSQL function xata_private.check_object_count() line 11 at SQL statement

Using the current free tier that reports itself as "PostgreSQL 15.5".

[exekias]

Thank you for reporting! We have identified the issue and a fix is in the works. I will post an update here once it's available.

Kind regards