Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kB2I0-0001nh-IM for pgsql-bugs@arkaria.postgresql.org; Wed, 26 Aug 2020 20:45:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kB2Hz-0006qK-F4 for pgsql-bugs@arkaria.postgresql.org; Wed, 26 Aug 2020 20:44:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kB2Hz-0006qD-4f for pgsql-bugs@lists.postgresql.org; Wed, 26 Aug 2020 20:44:59 +0000 Received: from mail-qt1-x841.google.com ([2607:f8b0:4864:20::841]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kB2Hu-0004sF-Pn for pgsql-bugs@postgresql.org; Wed, 26 Aug 2020 20:44:58 +0000 Received: by mail-qt1-x841.google.com with SMTP id d27so2758804qtg.4 for ; Wed, 26 Aug 2020 13:44:54 -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=Q/zJ8ZRIZHvJvNrkLD+iy0fkFqtwkdB+VxAxofqV2Rc=; b=CSznwyM4m8Xcjdf4RTo7cGiwXCuh1GjblFrlff0KR6Xzi820aKYa77365EJltarC7e 1SnsTInzfQ1MGwner6tz/SLrwx2qa5MQHW0a+MNL5NHVSPdr1jBA3srISHhZ7lVahcqW ewe6B1PQ0FqGiB+zrkjNMfOZ5y4gM/bja08WvqH9nWAjbObwhV9fi6zx5/AWFVZxazMp AuXQVm3qQZnQlsqNHUzvzssWrsOI4lC73eqW0PxPfhpAVEOoDi7atKHLpl8husp3lXlz z24UmmLwTzKC3/KTV8heyrskNTHFYgvBEkje3UtGRnc29OxZpxeXXNCbg4DOm7baNR5n 7E9w== 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=Q/zJ8ZRIZHvJvNrkLD+iy0fkFqtwkdB+VxAxofqV2Rc=; b=fNa660/68v3RN6Ems6Elez2mtRKUPtAeT0oLYTH7DMzGsw6CSJlMY3jIPs/q3wsqrP lkiWes1NXLV5ikULvqOnpLPVZxgKDORv3yDe8yjAvVgIMdfOGdCUpoZNJiX+QS743jom fOd0N/8Nt3lAJAlB5BWntrOn5GczMGhYlu/mRFR25YPPTo0vqycjRCNeV7eKatEti5Ht Mt+PJO7xBhfYLhl4thClQ3+YE7lCNXRuW0MSpcy/jY2/n7dA1XtcJ59vFaypBbJaMGM8 MxtM1O7X2/BcRQjIjK8Q4fDBxjwdUidVRSgPXlFYsbqw2Nke2NXtymbEYlbaJmLufPrb 2uiA== X-Gm-Message-State: AOAM532bW/EwtUM1WdQSAwDSqvX0Xfg9SYleC/TNvFrnte+v2AOzz6s0 9irzKz8wjPvVpPos11e7SxWmjg== X-Google-Smtp-Source: ABdhPJw6NvwlXRbfQ1cHznz034W+ov/PJuguNIUK+uR4XV0Q3Ra7M2bzM4dhfk/V3zZTHNV4BhX1ow== X-Received: by 2002:ac8:76d3:: with SMTP id q19mr5020346qtr.120.1598474693078; Wed, 26 Aug 2020 13:44:53 -0700 (PDT) Received: from perhan.alvh.no-ip.org ([190.95.19.47]) by smtp.gmail.com with ESMTPSA id i66sm143380qkc.63.2020.08.26.13.44.52 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 26 Aug 2020 13:44:52 -0700 (PDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 0B0322A19E4; Wed, 26 Aug 2020 16:44:51 -0400 (-04) Date: Wed, 26 Aug 2020 16:44:51 -0400 From: Alvaro Herrera To: Robins Tharakan Cc: Michael Paquier , pgsql-bugs@postgresql.org Subject: Re: ALTER TABLE ALTER COLUMN SET TYPE crash Message-ID: <20200826204451.GA26440@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-Aug-26, Robins Tharakan wrote: > For now though, I need to see how to exclude some functions. The above > use-case has pretty much rendered my test-setup useless - since it easily > triggers engine restarts every few minutes. An easy workaround from Postgres POV might be to patch it to return an error on ATExecAlterColumnType or so. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services