Re: partitioned tables referenced by FKs - Mailing list pgsql-hackers

From Robert Haas
Subject Re: partitioned tables referenced by FKs
Date
Msg-id CA+TgmoY_amZOueJeR3K9wsLvpSKSQvKwNcCMTsHeXuAuHXC06A@mail.gmail.com
Whole thread Raw
In response to Re: partitioned tables referenced by FKs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, Apr 2, 2019 at 11:07 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The problem this patch is running into is that we'd like to make the
> validity of dropping a table partition depend on whether there are
> individual rows in some other table that FK-reference rows in the target
> partition.  That's just completely outside the object-dependency model,
> and I'm not sure why Robert finds that surprising.

I think it's because I was misunderstanding the problem.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Refactoring the checkpointer's fsync request queue
Next
From: Fujii Masao
Date:
Subject: Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation