Question about accessing partitions whose name includes the schema name and a period - is this correct?

t count(*) from "my_schema"."my_schema.my_table_should_not_work"; ERROR: relation "my_schema.my_schema.my_table_should_not_work" does not exist Does anyone have any insights regarding how this partition could be renamed or detached? I've reviewed the mailing list archive and other sources and haven't been able to find anything similar. Thanks everyone! -Jay Stanley, DBA -Cycorp: The Why behind AI Long-time lurker, first-time poster.

Re: Question about accessing partitions whose name includes the schema name and a period - is this correct?

On 2023-04-19 21:42, Tom Lane wrote: Jay Stanley writes: I've come across some interesting behavior with regards to creating a partition of a table that includes the schema name and a period in the beginning, so that the resulting name is like "

Re: PostgreSQL DB in prod, test, debug

7;create database DBNAME template TEMPLATENAME' as well as 'alter database DBNAME set datistemplate = true|false'. - jay stanley - https://cyc.com; The Next Generation of Enterprise AI