Hi Paul,
On 2019/05/21 13:25, Paul A Jungwirth wrote:
> I'm sorry if this is the wrong place for this or it's already been
> covered (I did scan though this whole thread and a couple others), but
> I noticed the docs at
> https://www.postgresql.org/docs/devel/ddl-partitioning.html still say
> you can't create a foreign key referencing a partitioned table, even
> though the docs for
> https://www.postgresql.org/docs/devel/sql-createtable.html have been
> updated (compared to v11). My understanding is that foreign keys
> *still* don't work as expected when pointing at traditional INHERITS
> tables, but they *will* work with declaratively-partitioned tables.
You're right. I think it's simply an oversight of f56f8f8da6, which
missed updating ddl.sgml
> (I've also attached it as a patch file.) In other words, we should
> move this caveat from the section on declaratively-partitioned tables
> to the section on inheritance-partitioned tables.
>
> Sorry again if this is the wrong conversation for this!
Thanks for the patch. To avoid it getting lost in the discussions of this
thread, it might be better to post the patch to a separate thread.
Thanks,
Amit