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 1sJwte-007WSv-4g for pgsql-admin@arkaria.postgresql.org; Wed, 19 Jun 2024 15:06:50 +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 1sJwtb-000Xds-24 for pgsql-admin@arkaria.postgresql.org; Wed, 19 Jun 2024 15:06:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sJwta-000Xdk-Cp for pgsql-admin@lists.postgresql.org; Wed, 19 Jun 2024 15:06:47 +0000 Received: from mail-ed1-x533.google.com ([2a00:1450:4864:20::533]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sJwtY-0025wC-OU for pgsql-admin@lists.postgresql.org; Wed, 19 Jun 2024 15:06:45 +0000 Received: by mail-ed1-x533.google.com with SMTP id 4fb4d7f45d1cf-57ccd1111aeso5080424a12.0 for ; Wed, 19 Jun 2024 08:06:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1718809603; x=1719414403; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:cc:to:from:subject:message-id:from:to :cc:subject:date:message-id:reply-to; bh=nB8jMokxpO7lc3vY7TG2GixULeLMMYZ7iWsL0vMkJDQ=; b=FK0mn3C8rab3QJJRqqkJ2dyVERIUCbapQJ9eD3yWRV/1vFmky9zRqkOiRFCs3MRr6O xekjEcvNgdVK5UzL6QxNaJMQH6kTpozfHoIRYscwfP7gRTwWi/laQ9igd6XfTuXRzVuG Uh6YWDT93U4FtSuheIK9Ytfqz8LGSHyRFLu6tG+Eh+av0GJECXKykX9HIfuglz5dyXl4 /8d3ozFISHwndKs19XvN1w3/WFOhmX+njdMRII61Cd4bguhl/MbwWxs8hdI8uTbAwaXN gz/OSIySXTHIkAFdOPqfwZoVQS5OtVwComlW38oFumsC5LSO/mlVrBOd1CUNCOa/wPY5 galA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718809603; x=1719414403; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:cc:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=nB8jMokxpO7lc3vY7TG2GixULeLMMYZ7iWsL0vMkJDQ=; b=oGHkUoWG4BxyGhrKHIb7+fx7w/v6790ZVonnKVmE6Rf5Wwk320wHkqVi2mCAet2mth wQLMQR8y43QljSBTs0dd5+uQQyWzZ0Uo2DGLJxEBh0FeKSz7JFu98j/njsVw4EBXNqQ9 QIh0NXQbz2LqknHkrngmNR/Q5tylR8nGAHXO41nQo3XMm2KYVchrYW17hG79chqWL9eV Qtwv8W/hHilrsswpquk3yqkM+SUlWDs7OXo+o0XXeQEGsYbniRK3eZe0vHYAW8G+IHhD ieo8NFVkSY6n/3S18if+u5RanjB6+tOZXgPvt2YdOOqv7Hl+IcBSqo0bXAMnKF0jVHJT V3yg== X-Forwarded-Encrypted: i=1; AJvYcCWl6zPADemf+5nrj70q8lqRFsVYzB0rTNXJjqc3ktOsAKTEeAgSRvRIt26Ju49kjFIlSewcrbUPMM/ugFoGL+v37NkNcO3b1nK8C1MPAg74PA== X-Gm-Message-State: AOJu0YyZUMCRSQ99Uyf1lInKueSCNTMOsWrswqZF1j9T1b/o8SUlHAII vFHwDzawseOW+KgPgtU9FHfsfTMMObgJH8KWdK+H1EGU/F/1HabQ2GRTJ+fKrkY= X-Google-Smtp-Source: AGHT+IHY+wS32Ep5GmIJMqrXXb2+/FLtF1iEgtz6i7Rcfi0Vnwibe5gzCnXifi02hliIY4wY7M8kKg== X-Received: by 2002:a50:9fcb:0:b0:57c:70b0:d541 with SMTP id 4fb4d7f45d1cf-57d07e6bd08mr1738816a12.20.1718809602826; Wed, 19 Jun 2024 08:06:42 -0700 (PDT) Received: from localhost.localdomain ([2001:871:260:9db9:fac:6e88:4edf:f1b9]) by smtp.gmail.com with ESMTPSA id 4fb4d7f45d1cf-57cb72da708sm8504709a12.37.2024.06.19.08.06.42 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 19 Jun 2024 08:06:42 -0700 (PDT) Message-ID: Subject: Re: Statement_timeout in procedure block From: Laurenz Albe To: Tom Lane Cc: Teja Jakkidi , pgsql-admin Date: Wed, 19 Jun 2024 17:06:41 +0200 In-Reply-To: <114105.1718809113@sss.pgh.pa.us> References: <46a33904c2cd86718cb4d7a0291906a08b8e246a.camel@cybertec.at> <114105.1718809113@sss.pgh.pa.us> Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2024-06-19 at 10:58 -0400, Tom Lane wrote: > Laurenz Albe writes: > > What works is setting the parameter on the procedure: >=20 > > test=3D> CREATE OR REPLACE PROCEDURE sit() LANGUAGE plpgsql SET stateme= nt_timeout =3D 2000 AS 'BEGIN PERFORM pg_sleep(5); END;'; > > CREATE PROCEDURE >=20 > That doesn't work either, for me, and I would not expect any of these > variants to do so. Ah, you are right. It was the SET statement in the previous incarnation of the procedure that had changed the parameter for my database session. Yours, Laurenz Albe