Clarification needed: create partition table can be in another schema other than that of the parent table

Поиск
Список
Период
Сортировка
От 周志勤
Тема Clarification needed: create partition table can be in another schema other than that of the parent table
Дата
Msg-id 048B376714E008E5+202405141544517974659@dualhelios.com
обсуждение исходный текст
Ответы Re: Clarification needed: create partition table can be in another schema other than that of the parent table
Список pgsql-bugs
Дерево обсуждения
Hi Pgsql bugs,

I have the following scenario:

ptable sits in schema:BBB

create table AAA.ptable18250w partition of BBB.ptable for values from (180000000) to (182500000);

Now the ptable has a partition table: ptable18250w sits in schema AAA. 

Is this what we intent to do or an issue? as we do a sql search under schema BBB, we will never find this table,which causes a lot of confusion for me.

Looking forward to your reply.

Thanks and best regards,
Joe

joe.zhou@dualhelios.com

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

Предыдущее
От: Ugur Yilmaz
Дата:
Сообщение: Ynt: Postgresql 16.3 installation error (setup file) on Windows 11
Следующее
От: 周志勤
Дата:
Сообщение: 回复: Clarification needed: create partition table can be in another schema other than that of the parent table