Partition table with a foreign key self-reference

Поиск
Список
Период
Сортировка
От Oliver Urones
Тема Partition table with a foreign key self-reference
Дата
Msg-id CAH2eNKX7wg7mZYr6jt4c6iZey6HYQUY-3DLPJMT3wWqy1gNFmg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Partition table with a foreign key self-reference
Список pgsql-admin
Hello.

I need help with the process of partitioning tables.

How can I partition a table that has a foreign key that references itself?

Something like this example:

CREATE TABLE employees (
    employee_id SERIAL PRIMARY KEY,
    name VARCHAR(50),
    boss_id INTEGER,
    CONSTRAINT fk_boss FOREIGN KEY (boss_id) REFERENCES employees(employee_id)
);

I'm using Postgresql 14.

Thanks!

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