Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sp6t8-00GeZ4-Jo for pgsql-bugs@arkaria.postgresql.org; Fri, 13 Sep 2024 14:03:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sp6sA-003NQh-6V for pgsql-bugs@arkaria.postgresql.org; Fri, 13 Sep 2024 14:02:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sp2Hy-00GfGP-8S for pgsql-bugs@lists.postgresql.org; Fri, 13 Sep 2024 09:08:26 +0000 Received: from mail-wm1-x32f.google.com ([2a00:1450:4864:20::32f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sp2Hr-000xW5-K1 for pgsql-bugs@lists.postgresql.org; Fri, 13 Sep 2024 09:08:25 +0000 Received: by mail-wm1-x32f.google.com with SMTP id 5b1f17b1804b1-428e1915e18so5825275e9.1 for ; Fri, 13 Sep 2024 02:08:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=deepbluecap-com.20230601.gappssmtp.com; s=20230601; t=1726218499; x=1726823299; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=eVshuk6UxtV7WD22LiOv6xTDaAAW0IvJI1pmSVu0hH4=; b=jDNaxkP/GQEKoC02R6tQJGgrYAKJ2hw+CKFKz5Hos5OMYyyPt7srI2/dKBXT5pEtAU nc0UivGGwxw5kENk0tRvueqpTb5Y2QEEQ8WzBzK6hTaajgsUQyhdPVBZlP5dhZws+VGZ KaNBYoS64/lYc3XNxr9OfhHvzkFcq6+uz3f8Zlpl6QjRPdghIyA6cBawUKNUT2yPfiol XpEMqm1DKnD+N1Xb+jjLGuFYTc51bu+ZV6fSVxqIRzf/vm8HqqX6bkxAjn2z29er0XSJ b9fftONRkDjAO/ff6tRKwaqSbNf6UqiFUioq5w5rAOW3pNUOI8YCFBU6AP6amoNmUfJu I28Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726218499; x=1726823299; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=eVshuk6UxtV7WD22LiOv6xTDaAAW0IvJI1pmSVu0hH4=; b=nA69L1SMPUm2MuDBk/D0M6pTpePopadbb4qNVqGuzoRgdb3qqkkVaM+cgNjE48qYP7 5JQLeqTxXA2fThQujxtZY1ZI9r2uJ1gj2Mi3SNdo57jhyb+UBvmCEi0QitmeykZERoNg oD1c4vLY/XhMff6TYzhn01Fhmfa9oh7pYbbPCokMXluOUluOwSYnntORY5tx1nN5uaIB MtgjJfd80MV40cQaWM16B7SCxFU1jv2KP29BShMSQOcZgl+Rf9L7f9BLj0xU0zRuNHiF s1vIhSun5QT3YefvWgAWlYcucxTf6TRkucsZaoCduD8poybik6HQ1yRJsWeeziZ73Nun nmwQ== X-Gm-Message-State: AOJu0YwSDJ1mmmTNy4cfoqCAHmZ4bsL6ReF6c22eIqJAWQcSqJUfIBKf in6NNFNpHDuWUvF6AdToA0LTyFmd672wqCKgoKDAgQHWqk0lHRsI699urc65qOk= X-Google-Smtp-Source: AGHT+IGjRDkUVaeCIBElCzy/7UOulAwtxhur7VkqU3oI+qkAo+fh+ACMGJfcnzruJgK+bj/7WLy5dQ== X-Received: by 2002:a05:600c:4753:b0:42c:b0a4:6b67 with SMTP id 5b1f17b1804b1-42d964f857fmr14276815e9.34.1726218497741; Fri, 13 Sep 2024 02:08:17 -0700 (PDT) Received: from ?IPV6:2a01:e0a:255:1000:62b5:e310:63f5:e5eb? ([2a01:e0a:255:1000:62b5:e310:63f5:e5eb]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-42d9b05a65asm17202595e9.6.2024.09.13.02.08.17 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 13 Sep 2024 02:08:17 -0700 (PDT) Message-ID: <89aae487-4168-406d-a5e5-2f0c790634e6@deepbluecap.com> Date: Fri, 13 Sep 2024 11:08:16 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pg_restore with --disable-triggers discards ENABLE ALWAYS To: Tom Lane , Laurenz Albe Cc: pgsql-bugs@lists.postgresql.org References: <78a13f951a03bf325027f8dcfb32b1b5089cdb14.camel@cybertec.at> <4156698.1726174027@sss.pgh.pa.us> Content-Language: en-US From: Duncan Sands In-Reply-To: <4156698.1726174027@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Tom, I accidentally sent my previous reply without completing it. Here's the rest: Your suggestion as to the root cause certainly sounds plausible. If no-one has the energy to fix it, maybe it's best to at least add a note about this in the pg_restore --disable-triggers documentation. Best wishes, Duncan.