Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1hIeIg-0007IB-NZ
	for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Apr 2019 19:08:22 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1hIeIf-0001Wn-6b
	for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Apr 2019 19:08:21 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1hIeIe-0001Wf-Qa
	for pgsql-hackers@lists.postgresql.org; Mon, 22 Apr 2019 19:08:20 +0000
Received: from mail-qt1-x842.google.com ([2607:f8b0:4864:20::842])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1hIeIb-0006ff-HK
	for pgsql-hackers@lists.postgresql.org; Mon, 22 Apr 2019 19:08:19 +0000
Received: by mail-qt1-x842.google.com with SMTP id s15so13341181qtn.3
        for <pgsql-hackers@lists.postgresql.org>;
 Mon, 22 Apr 2019 12:08:17 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623;
        h=date:from:to:cc:subject:message-id:mime-version:content-disposition
         :content-transfer-encoding:in-reply-to:user-agent;
        bh=oiUolAWtKTOW1uQGLUVC7XeAO8E4eZBJXgqkqnvTQKA=;
        b=izAVqjQZ+jYjaejASV6pkBxJIWffxXZAa9TdN3r2K2QZrHpfHLdkG2ZlNyfLK+5hGs
         QJUTZ76+2ZycYVhEwYH3iFYgNEjqtGXE35Nn6iGZSUpUI8a4h4ifjDmY7Gdyq9SDC/FO
         4VjhOIJAo4TWn7UDnbM8+jQXOtT/yz49BSeBWWnduOrLShm6295JG4r/CnQKwcU2XX0q
         X/CU+5EdIdxQ6RZTx6QfwiLtykeLc2R9GU6euq3VUzpzltHPJ+b8uCWLhQmLAf4TbWnr
         7f2fD/TfruKh85AN7x705++vffMgLB7DWfS4XVryAdNE6eNqJXy6VwpnnoBsvFUkuuFS
         UgIw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version
         :content-disposition:content-transfer-encoding:in-reply-to
         :user-agent;
        bh=oiUolAWtKTOW1uQGLUVC7XeAO8E4eZBJXgqkqnvTQKA=;
        b=inqgYLfPhhDxDzTyoWfBsbCtNcUyMfn8gDzMNZuNDB8PoizvEsH6Bgu0U88iD4PkUb
         SYJPj4GXYn4oLl68ah0bfFTShAl9mIEzAplGXd3TgQzuOKoe8kskuEl4d8pAtkpo8H58
         GczwfqYi4+U+xEsO9pBROREyWQ4cpoQNClmja/7EtCR4JAxUpMljnyJo1HuzNagEIP7Y
         D7Gnr3SM8inevq7W0LGVEiGsO3eoACF9TT8CQkfYbhhaheWcbOB088AH5nJZ1u2ymk0n
         JTfwUtgcUeIW+v7es4UMeNnIMBL+CfpeHwHYcFF27mrrmuJMaBH82drrpXM52/3ivJ84
         FSVA==
X-Gm-Message-State: APjAAAWnx64oTbEKzpuwPOxLkivfyggE1zvYvkemUvQnbj2QYJ/NLEZX
	ojFSJ0hruBL18uGtkM1JesEQkQ==
X-Google-Smtp-Source: 
 APXvYqw25chlJw0A8ih6LLayKz52KC2SEZSxWQNVsrB/yGPJN3y7IJY0y7I7nLHXCeGg82xvB8XFsQ==
X-Received: by 2002:ac8:148a:: with SMTP id l10mr14885248qtj.62.1555960096547;
        Mon, 22 Apr 2019 12:08:16 -0700 (PDT)
Received: from nimloth.alvh.no-ip.org ([179.56.48.227])
        by smtp.gmail.com with ESMTPSA id 12sm1179146qtb.4.2019.04.22.12.08.15
        (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256);
        Mon, 22 Apr 2019 12:08:16 -0700 (PDT)
Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000)
	id 60AC312069F; Mon, 22 Apr 2019 15:08:13 -0400 (-04)
Date: Mon, 22 Apr 2019 15:08:13 -0400
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Andres Freund <andres@anarazel.de>
Cc: Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	David Rowley <david.rowley@2ndquadrant.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: pg_dump is broken for partition tablespaces
Message-ID: <20190422190813.GA30369@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20190422182050.a73zl4wkfwx2ujou@alap3.anarazel.de>
User-Agent: Mutt/1.9.4 (2018-02-28)
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

On 2019-Apr-22, Andres Freund wrote:

> Why is the obvious answer is to not just remove the whole tablespace
> inheritance behaviour?

Because it was requested by many, and there were plenty of people
surprised that things didn't work that way.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services