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 1n2ZUC-0007WG-0q for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Dec 2021 13:59:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n2ZUA-0003x2-Ja for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Dec 2021 13:59:22 +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 1n2ZUA-0003wt-6z for pgsql-hackers@lists.postgresql.org; Wed, 29 Dec 2021 13:59:22 +0000 Received: from mail-il1-x129.google.com ([2607:f8b0:4864:20::129]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n2ZU7-0000m7-3U for pgsql-hackers@lists.postgresql.org; Wed, 29 Dec 2021 13:59:20 +0000 Received: by mail-il1-x129.google.com with SMTP id u8so16665058ilk.0 for ; Wed, 29 Dec 2021 05:59:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=oKJGNDl8J4TURdYamiHXL3qo0+zW2dHajM8Gtzv2cvk=; b=txGae80eVqvBAd6BMtki913xokyFvdd4H8NxT0GNT0+R5CSs3j/ghu3NS02R0ThGc6 ht7/IUz6MeFIQVn/ESKkxCo6dgnTJfZKynmiOBOkgrVbN+kY6fW2g7Vbybm8+8K/FcN5 AVxlizr4CSMMHL0AFHa/EPbllXG/igZjJ1i/WyOk+0pxA92cBCJoiS0/rqaG8GlYwV60 lwdOkqveQ5EHts3+GIrrtID0GqObx+qePgO9m3KZhR2i1c+Gls0VMV9E1la/OQ19w+vx iYOD8LwE553UOdbkUZr/VkjIGv1PoOlVp6SfXDIx+17k7SfR0winxmgG9lFveUnUWuHz uMQQ== 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:user-agent; bh=oKJGNDl8J4TURdYamiHXL3qo0+zW2dHajM8Gtzv2cvk=; b=v3ZiEcwehaRKpYbRk0kx8lqtYDOOfb8+TQN7lzTxxRQNHnp0zmX1rLJ4wGqFfa5Ody jURMStEvGHWkhZgA47jpgcYvFl/1sCtDYF9332w6DGTRDiwhLd6gWw8zAFb6jlYYVFHn +kx/XuFYtsndV6C46OH1JTIUHKXDsYSVgQ1T884wEWmq+MV3t5K7WJImHh8V1xpL/+V1 gk7H/7Vz3/NyYhveasetSD8uzzAqk2Dum6yNW/QjK/LoZgr77m2hbeh4unk25fRx0U5k Mc3ABdnMcFp92OmEqO4fwhG8c/ipe/LVrz+ZgaNwhsZZppkNc3n4M8IDOuX528IVT+oe +g7Q== X-Gm-Message-State: AOAM531UmJkN2/hq/ZMlTKeB0aiCtXmMUuSMetx+ukAR4FlntHsPjFmN C0JcsonasjeyzKLfhuCbAZ37Eok1xoOz3Q== X-Google-Smtp-Source: ABdhPJwgHbQCNUXaO3rr5xE/vNRBJ0AUGF20wyvUx7ohFGJG90A2qd3FFl8RLvJVOzdgUhmTRYTd6w== X-Received: by 2002:a05:6e02:170c:: with SMTP id u12mr11872885ill.53.1640786357643; Wed, 29 Dec 2021 05:59:17 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id c19sm13663372ioa.30.2021.12.29.05.59.17 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 29 Dec 2021 05:59:17 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 7B5B28005CB; Wed, 29 Dec 2021 07:59:16 -0600 (CST) Date: Wed, 29 Dec 2021 07:59:16 -0600 From: Justin Pryzby To: Ronan Dunklau Cc: Alvaro Herrera , pgsql-hackers@lists.postgresql.org Subject: Re: Proposal: More structured logging Message-ID: <20211229135916.GN24477@telsasoft.com> References: <202108191304.u7g5wwuepwpe@alvherre.pgsql> <1745789.A5U81WbCk6@aivenronan> <3358218.yRJqF8fxcQ@aivenronan> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3358218.yRJqF8fxcQ@aivenronan> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > Subject: [PATCH v3 2/3] Add test module for the new tag functionality. ... > +test_logging(PG_FUNCTION_ARGS) > +{ ... > + (errmsg("%s", message), > + ({ > + forboth(lk, keys, lv, values) > + { > + (errtag(lfirst(lk), "%s", (char *) lfirst(lv))); > + }}) > + )); The windows build fails with that syntax. http://cfbot.cputube.org/ronan-dunklau.html https://ci.appveyor.com/project/postgresql-cfbot/postgresql/build/1.0.157923 > Subject: [PATCH v3 3/3] Output error tags in CSV logs > +++ b/doc/src/sgml/config.sgml > @@ -7370,6 +7371,7 @@ CREATE TABLE postgres_log > backend_type text, > leader_pid integer, > query_id bigint, > + tags jsonb > PRIMARY KEY (session_id, session_line_num) > ); > That's invalid sql due to missing a trailing ",". You should also update file-fdw.sgml - which I only think of since we forgot in to update it before e568ed0eb and 0830d21f5. config.sgml should have a comment as a reminder to do that. -- Justin