Re: Partition table with a foreign key self-reference

I can't help if am not present I need to follow rules
Juan Rincon

On Tue, Feb 4, 2025, 11:18 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:

> On Tue, 2025-02-04 at 16:57 +0100, Oliver Urones wrote:
> > 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.
>
> The question makes no sense as such. You'd have to tell us the purpose
> you want to achieve with partitioning. Depending on that, you'd choose
> the partitioning strategy and the partitioning key.
>
> At any rate, you'll probably have to drop the foreign key constraint
> unless your partitioning key is "id".
>
> Yours,
> Laurenz Albe
>
>
>