Re: [GENERAL] Debian Bug#859033: pg_dump: creates dumps that cannot be restored

2017-03-31 Thread David G. Johnston
On Fri, Mar 31, 2017 at 8:21 AM, Thorsten Glaser wrote: > On Fri, 31 Mar 2017, Adrian Klaver wrote: > > > > ① that using a CHECK constraint to check data from another table > > > is wrong (but not why), and > > > > Because that is a documented limitation: > > > > https://www.postgresql.org/docs

Re: [GENERAL] Debian Bug#859033: pg_dump: creates dumps that cannot be restored

2017-03-31 Thread Adrian Klaver
On 03/31/2017 08:21 AM, Thorsten Glaser wrote: On Fri, 31 Mar 2017, Adrian Klaver wrote: ① that using a CHECK constraint to check data from another table is wrong (but not why), and Because that is a documented limitation: https://www.postgresql.org/docs/9.6/static/sql-createtable.html "C

Re: [GENERAL] Debian Bug#859033: pg_dump: creates dumps that cannot be restored

2017-03-31 Thread Thorsten Glaser
On Fri, 31 Mar 2017, Adrian Klaver wrote: > > ① that using a CHECK constraint to check data from another table > > is wrong (but not why), and > > Because that is a documented limitation: > > https://www.postgresql.org/docs/9.6/static/sql-createtable.html > > "Currently, CHECK expressions can