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 1oIS3P-0006mP-PT for pgsql-admin@arkaria.postgresql.org; Mon, 01 Aug 2022 09:49:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oIS3N-0002uU-Mt for pgsql-admin@arkaria.postgresql.org; Mon, 01 Aug 2022 09:49:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oIS3N-0002uK-5s for pgsql-admin@lists.postgresql.org; Mon, 01 Aug 2022 09:49:37 +0000 Received: from mail-pl1-x635.google.com ([2607:f8b0:4864:20::635]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oIS3K-0005Fu-MT for pgsql-admin@lists.postgresql.org; Mon, 01 Aug 2022 09:49:36 +0000 Received: by mail-pl1-x635.google.com with SMTP id q22so1809989plr.9 for ; Mon, 01 Aug 2022 02:49:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=p6E15DnPUtUBA+hAX9jReBbokA4TkXr32awcKZcpYjQ=; b=EGeClyi15fn9QXQU/+KifQLoUORUVrFUp1EyKZnh5viAkll2oJFEv+abV34qxjojYo FdR8z/h1ED4BqQwkG9S+0wV2q7UfJC9p26etAgb+ITj3tBMny1cAjwpM1nyQNo2GpSE+ 2po3lPo5AFi8q6UK7xjPaoq0Uxq2JUuwEb1pu5tEWvnobbxlMSXeLWVdXPDJ4tpz1uVi dCLDF9aCXZ5/RqLA4ZAWAur49s1wpDz0sZIQEs80j1SIKWHzLi8eGLPC0kmNs+DiX0JP mWZ/fpMwcJtpC2sXV6s2jz/qf0+2Xal9KXTuyzF5/+WpVoaomwN1TrgNU1STCV+EXCGV Mr/A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=p6E15DnPUtUBA+hAX9jReBbokA4TkXr32awcKZcpYjQ=; b=76U+zgUVaNLlR2ZWjV63weXalTX3i8I4JNvc4KS/33R/zlSb3PKG3E+6FWlz4Y7UJ9 +rS4amMdHysR8Kj6tad6oSiObMjGIsES7FHG7S18HuoFVDg4bICh85PqJdtabJk9uoTB GrkcnRoeZA5uFed9MOFxcHE73d1cKKwb5+lIq4sXmHvUHUDV6KUPGhxoT5mgtQSrvnA8 I7+8TuIID275aqn7eBMLSN8gMkUf1Dn7W9JSBiy09KbD8oBI9dGRaA+TxrX3AM4yz/J/ yFiJP8a1ddI8PkCyUDVkJA8OZxVrHeRLZxyqDKgF9FJXFDuqKMQf8mGsiz5PVtcf4G2O cpOg== X-Gm-Message-State: ACgBeo2YLnQ+kuhbohJirV7XDnwKXcGheP/AR3EL8Pb0doaNQcrz7iah N6x+uf5Gp0BkrA8aoOqGkfY= X-Google-Smtp-Source: AA6agR5cCkuXSKG4E75Sdh+sf82s4BMng3eLG+OExPHeXoAxLtt69WMJ23iEk4ffIj7S/bmxkeEkzQ== X-Received: by 2002:a17:903:d4:b0:16d:bb31:f66 with SMTP id x20-20020a17090300d400b0016dbb310f66mr15754307plc.60.1659347373615; Mon, 01 Aug 2022 02:49:33 -0700 (PDT) Received: from jrouhaud ([210.176.45.84]) by smtp.gmail.com with ESMTPSA id y126-20020a62ce84000000b0052d9c4a7f77sm1091445pfg.34.2022.08.01.02.49.32 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 01 Aug 2022 02:49:33 -0700 (PDT) Date: Mon, 1 Aug 2022 17:49:29 +0800 From: Julien Rouhaud To: Vincent Predoehl Cc: pgsql-admin@lists.postgresql.org Subject: Re: Debugger for plpgsql Message-ID: <20220801094929.z2h3yiaydao3qidv@jrouhaud> References: <755186BD-D6D7-443F-80B7-C115932A54C7@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <755186BD-D6D7-443F-80B7-C115932A54C7@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Sun, Jul 31, 2022 at 04:09:41PM -0500, Vincent Predoehl wrote: > Is there a Debugger for postgresql? The only thing I could find was > PLDebuggef and I had trouble getting it to compile. You meant for plpgsql then? A bit unrelated, but if you're doing any non trivial code in plpgsql you should definitely use plpgsql_check (https://github.com/okbob/plpgsql_check). It's an incredibly useful extension that will avoid a lot of problems.