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

Поиск
Список
Период
Сортировка
От Michel Helms
Тема pg_table_size errors "invalid name syntax" for table names containing spaces
Дата
Msg-id CAGJ6MEz=FRwezJSGf8c9YbV7-OTScYTQrdx=Y5OcLwWb9WNdFg@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_table_size errors "invalid name syntax" for table names containing spaces
Список 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17053: Memory corruption in parser on prepared query reuse
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17054: Memory corruption in logical replication worker when replicating into partitioned table