pg_table_size errors "invalid name syntax" for table names containing spaces

From: Michel Helms <michel(at)togetherdb(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: pg_table_size errors "invalid name syntax" for table names containing spaces
Date: 2021-06-10 08:57:37
Message-ID: CAGJ6MEz=FRwezJSGf8c9YbV7-OTScYTQrdx=Y5OcLwWb9WNdFg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi

Sorry I am not used to mailing lists so please excuse me if I am not doing
this correctly.

Also I am operating on PostgreSQL 13.2, so not the newest version, but I
have no way to upgrade right now or to test on the most recent version and
it should be really easy to test for anyone who has the recent version
running.

Without further ado, this fails for me and I think it shouldn't:

CREATE TABLE "wei rd" (id SERIAL);
SELECT pg_table_size('wei rd');

So just creating a table containing spaces, the pg_table_size, also
pg_total_relation_size and maybe other administrative functions fail with
error message "invalid name syntax".

Thanks
Michel from TogetherDB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2021-06-10 09:21:39 BUG #17054: Memory corruption in logical replication worker when replicating into partitioned table
Previous Message Tom Lane 2021-06-09 21:41:36 Re: BUG #17053: Memory corruption in parser on prepared query reuse