Postgres Pro
Downloads
Home   >   mailing lists

pg_table_size errors "invalid name syntax" for table names containing spaces - Mailing list pgsql-bugs

From Michel Helms
Subject pg_table_size errors "invalid name syntax" for table names containing spaces
Date
Msg-id CAGJ6MEz=FRwezJSGf8c9YbV7-OTScYTQrdx=Y5OcLwWb9WNdFg@mail.gmail.com
Whole thread Raw
Responses Re: pg_table_size errors "invalid name syntax" for table names containing spaces  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #17053: Memory corruption in parser on prepared query reuse
Next
From: PG Bug reporting form
Date:
Subject: BUG #17054: Memory corruption in logical replication worker when replicating into partitioned table