[Pkg-postgresql-public] Processed: closing 859033

2017-03-31 Thread Debian Bug Tracking System
Processing commands for cont...@bugs.debian.org: > close 859033 Bug #859033 [postgresql-client-common] pg_dump: creates dumps that cannot be restored Marked Bug as done > thanks Stopping processing here. Please contact me if you need assistance. -- 859033: http://bugs.debian.org/cgi-bin/bugrepo

[Pkg-postgresql-public] Bug#859033: [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

[Pkg-postgresql-public] Bug#859033: [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

[Pkg-postgresql-public] Bug#859033: [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

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

2017-03-31 Thread Adrian Klaver
On 03/31/2017 07:34 AM, Thorsten Glaser wrote: Hi *, while I’d still appreciate help on the bugreport (context is this… https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=859033 … one), I’ve found this… http://dba.stackexchange.com/a/75635/65843 … which says ① that using a CHECK constraint to che

[Pkg-postgresql-public] Bug#859033: pg_dump: creates dumps that cannot be restored

2017-03-31 Thread Erwin Brandstetter
On Wed, 29 Mar 2017 21:18:39 +0200 (CEST) Thorsten Glaser < t.gla...@tarent.de> wrote: > > What have I expected? > > > > That pg_dump recognises the dependency (there is a FOREIGN KEY reference > > in there) and reorders the tables dumped. You should include the exact definition of the FOREIGN KEY

[Pkg-postgresql-public] Bug#859033: Debian Bug#859033: pg_dump: creates dumps that cannot be restored

2017-03-31 Thread Thorsten Glaser
Hi *, while I’d still appreciate help on the bugreport (context is this… https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=859033 … one), I’ve found this… http://dba.stackexchange.com/a/75635/65843 … which says ① that using a CHECK constraint to check data from another table is wrong (but not wh