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 ) id 1h9udT-0005uj-2l for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Mar 2019 16:45:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h9udR-0006eV-NY for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Mar 2019 16:45:41 +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 ) id 1h9udR-0006bT-BS for pgsql-hackers@lists.postgresql.org; Fri, 29 Mar 2019 16:45:41 +0000 Received: from mail-qt1-f169.google.com ([209.85.160.169]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9udO-0005hN-9T for pgsql-hackers@postgresql.org; Fri, 29 Mar 2019 16:45:40 +0000 Received: by mail-qt1-f169.google.com with SMTP id t28so3315457qte.6 for ; Fri, 29 Mar 2019 09:45:37 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:reply-to:subject:to:cc:references:from :organization:message-id:date:user-agent:mime-version:in-reply-to :content-language; bh=bUg11vGHbWvTmL4Iksd8xYYMbRa9xvuUnxy6oZNE0TE=; b=J4A4VUUR9ohB12jyZkw7AD0bfNPvzUlruYyhxCUwMMoN5q06z3FbkrflGkrMIrua0O FvxgLTiJ9LXPgR9xhcsWp0MylqgLN3PsmIDE8fTpwZrOTHZLAPGwq5H7mc4GTwunk/je 5+wh9CJuHvvJEBfr+3VtFPMjzcYcfehmGkgV46juUdiasdrUXnxHfv6te7T1DOb5cj7Z VniViMcrVEMOqWYv+GHL/6GQF0KcCoomHJZF3Gya24vqPw8lChETYxpoc0Fo36DPibpZ 3f8wvim2cvz30fcI+bB2VP027cKXa54ZUYuq57VaidqrrZj4+fpN5YkVu1yVX51AM6nz j0ww== X-Gm-Message-State: APjAAAWSaRmZYgKQpYg6gyxU1bqdBoT6flpTlI9QP1Z7WWrbu7DT4645 EftWVrW+gjJKfabHwB23uie11S1oCEM= X-Google-Smtp-Source: APXvYqxtZh5W3IPXqtNJ0RCD8g6oiEAGcH7srVVw3IqkQ3doxZ5pihcaObpy8N/rIY0bnQwgNThkng== X-Received: by 2002:aed:23ac:: with SMTP id j41mr2959724qtc.181.1553877936900; Fri, 29 Mar 2019 09:45:36 -0700 (PDT) Received: from localhost.localdomain (c-24-61-8-151.hsd1.ma.comcast.net. [24.61.8.151]) by smtp.gmail.com with ESMTPSA id b7sm1352073qkc.47.2019.03.29.09.45.35 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 29 Mar 2019 09:45:36 -0700 (PDT) Reply-To: jesper.pedersen@redhat.com Subject: Re: partitioned tables referenced by FKs To: Alvaro Herrera Cc: Amit Langote , Pg Hackers References: <20190329162933.GA1906@alvherre.pgsql> From: Jesper Pedersen Organization: Red Hat Message-ID: Date: Fri, 29 Mar 2019 12:45:35 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.4.0 MIME-Version: 1.0 In-Reply-To: <20190329162933.GA1906@alvherre.pgsql> Content-Type: multipart/mixed; boundary="------------32CD5854471C74F3EC865B0B" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------32CD5854471C74F3EC865B0B Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Hi, On 3/29/19 12:29 PM, Alvaro Herrera wrote: > On 2019-Mar-29, Jesper Pedersen wrote: >> Maybe the "(" / ")" in the CASCADE description should be removed from >> ref/drop_table.sgml as part of this patch. > > I'm not sure what text you propose to remove? > Just the attached. >> Should catalogs.sgml be updated for this case ? > > I'm not adding any new dependency type, nor modifying any existing one. > Are you looking at anything that needs changing specifically? > No, I just mentioned it if it was a requirement that the precise use-case for each dependency type were documented. Best regards, Jesper --------------32CD5854471C74F3EC865B0B Content-Type: text/plain; charset=UTF-8; name="droptable.txt" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="droptable.txt" ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvZHJvcF90YWJsZS5zZ21sIGIvZG9jL3Ny Yy9zZ21sL3JlZi9kcm9wX3RhYmxlLnNnbWwKaW5kZXggYmY4OTk2ZDE5OC4uMzI4MTU3Yzg0 OSAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL3JlZi9kcm9wX3RhYmxlLnNnbWwKKysrIGIv ZG9jL3NyYy9zZ21sL3JlZi9kcm9wX3RhYmxlLnNnbWwKQEAgLTQxLDkgKzQxLDkgQEAgRFJP UCBUQUJMRSBbIElGIEVYSVNUUyBdIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1ldGVyIj5u YW1lPC9yZXBsYWNlYWJsZT4gWywgLi4KICAgIHRyaWdnZXJzLCBhbmQgY29uc3RyYWludHMg dGhhdCBleGlzdCBmb3IgdGhlIHRhcmdldCB0YWJsZS4KICAgIEhvd2V2ZXIsIHRvIGRyb3Ag YSB0YWJsZSB0aGF0IGlzIHJlZmVyZW5jZWQgYnkgYSB2aWV3IG9yIGEgZm9yZWlnbi1rZXkK ICAgIGNvbnN0cmFpbnQgb2YgYW5vdGhlciB0YWJsZSwgPGxpdGVyYWw+Q0FTQ0FERTwvbGl0 ZXJhbD4gbXVzdCBiZQotICAgc3BlY2lmaWVkLiAoPGxpdGVyYWw+Q0FTQ0FERTwvbGl0ZXJh bD4gd2lsbCByZW1vdmUgYSBkZXBlbmRlbnQgdmlldyBlbnRpcmVseSwKKyAgIHNwZWNpZmll ZC4gPGxpdGVyYWw+Q0FTQ0FERTwvbGl0ZXJhbD4gd2lsbCByZW1vdmUgYSBkZXBlbmRlbnQg dmlldyBlbnRpcmVseSwKICAgIGJ1dCBpbiB0aGUgZm9yZWlnbi1rZXkgY2FzZSBpdCB3aWxs IG9ubHkgcmVtb3ZlIHRoZSBmb3JlaWduLWtleQotICAgY29uc3RyYWludCwgbm90IHRoZSBv dGhlciB0YWJsZSBlbnRpcmVseS4pCisgICBjb25zdHJhaW50LCBub3QgdGhlIG90aGVyIHRh YmxlIGVudGlyZWx5LgogICA8L3BhcmE+CiAgPC9yZWZzZWN0MT4KIAo= --------------32CD5854471C74F3EC865B0B--