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 1ovukW-0003fQ-GM for pgsql-docs@arkaria.postgresql.org; Fri, 18 Nov 2022 06:21:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ovukV-0000ge-3a for pgsql-docs@arkaria.postgresql.org; Fri, 18 Nov 2022 06:21:15 +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 1ovukU-0000gV-L1 for pgsql-docs@lists.postgresql.org; Fri, 18 Nov 2022 06:21:14 +0000 Received: from mail-ed1-x530.google.com ([2a00:1450:4864:20::530]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ovukN-0006rt-Iq for pgsql-docs@lists.postgresql.org; Fri, 18 Nov 2022 06:21:13 +0000 Received: by mail-ed1-x530.google.com with SMTP id 21so5780656edv.3 for ; Thu, 17 Nov 2022 22:21:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=mime-version:user-agent:references:in-reply-to:date:to:from:subject :message-id:from:to:cc:subject:date:message-id:reply-to; bh=8Mc1DCegexN1pRJZCCEJpeoNJHeVwI247UfoD505Sn4=; b=L1/D2x48Q2OqD+28D5/NBI6uPdzUMf0iuv7xof4W2ZpRPp+I59A6eCpDpwAcR+KVt0 KpCj3v2CE1NWGCCULeS5hg4n1PZracQi+CINyR65vWLMi1Xd5bK1eXs8vOwPmwilb4lE Sdjet2Vf9VsUt5+Xi+th84RMzc8uphyaxvfu8M+xcPcEGer8PdwkY78WwByQUmH51zI6 YpQkgyPFPb+5/PCiDb2JbUwJzzAlnfm3b+fjFNBANNZPI+wOjrcWSJQbolroGtwgnsds prZW3gRt8nkg9vqbNxseVJtJEzg7D4tMxUBFWTN4WRO128mi11fSeLpblAz0RTgFgYZi 6wHg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=mime-version:user-agent:references:in-reply-to:date:to:from:subject :message-id:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=8Mc1DCegexN1pRJZCCEJpeoNJHeVwI247UfoD505Sn4=; b=LjGe7Z4nwKetTtMx3fKSTwWTOjcdHpzj3+qJAIFlkB9LUU5bpJT683+361h4+9urdu VM1b+LYZf6d6GxK6LwNblD7OFzgA4Q8B3y5rgi6hJcBUMDFJxY1Lvs+j4pt0qPYt7L1q LcpfPggtpEz7JVW5d/eQsUiNKe7B0iRer9V/eWV6WbwM/lt/CsOY3F5if0otQcN3Y4Zz aG3qaL3wQ/f1eN5m0jMnROhzLIMKA6PlUcVpcde/84KlrJpSwLqjA2apD49YHwt63Gxj qipN8alZutCBJ7q8QQZWfq9j5myBKTh0IV/6wKjtSl5y6WZwfdMMVTmtrwVtu+EdVVW0 p3bQ== X-Gm-Message-State: ANoB5pmfKv1Ei3RaCHqvfZhWgo7eA7T5p7oFkthmc3nI9N0+jsagKW1w CFj4xWy4eevvKYI4M7oAzXZpXg== X-Google-Smtp-Source: AA0mqf4fbhYewgJT6a+IVTLbtOxzW3lNY6S70uXvLT/JM6hK3Vf+UT3EWYvf63yP9kQkrvQq5/j0IQ== X-Received: by 2002:a05:6402:4516:b0:467:b88c:f3af with SMTP id ez22-20020a056402451600b00467b88cf3afmr5030741edb.24.1668752464844; Thu, 17 Nov 2022 22:21:04 -0800 (PST) Received: from localhost.localdomain (178-190-172-206.adsl.highway.telekom.at. [178.190.172.206]) by smtp.gmail.com with ESMTPSA id y6-20020a17090614c600b007826c0a05ecsm1232075ejc.209.2022.11.17.22.21.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 17 Nov 2022 22:21:04 -0800 (PST) Message-ID: Subject: Re: Alignment issue at 43.10. Trigger Functions From: Laurenz Albe To: lemes.marcelo26@gmail.com, pgsql-docs@lists.postgresql.org Date: Fri, 18 Nov 2022 07:21:03 +0100 In-Reply-To: <166870885664.635.16667004450401573487@wrigleys.postgresql.org> References: <166870885664.635.16667004450401573487@wrigleys.postgresql.org> Content-Type: multipart/mixed; boundary="=-iPyTLBfyRW09EnB80u4Z" User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-iPyTLBfyRW09EnB80u4Z Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit On Thu, 2022-11-17 at 18:14 +0000, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/13/plpgsql-trigger.html > > Type alignment issue for salary at "Example 43.4. A PL/pgSQL Trigger > Function for Auditing": > > CREATE TABLE emp_audit( >     operation         char(1)   NOT NULL, >     stamp             timestamp NOT NULL, >     userid            text      NOT NULL, >     empname           text      NOT NULL, >     salary integer > ); Attached is a patch to fix that. Yours, Laurenz Albe --=-iPyTLBfyRW09EnB80u4Z Content-Disposition: attachment; filename="0001-Fix-text-alignment-in-an-example.patch" Content-Transfer-Encoding: base64 Content-Type: text/x-patch; name="0001-Fix-text-alignment-in-an-example.patch"; charset="UTF-8" RnJvbSA0Y2ZjN2VjNGI2NTVhODMxN2E5MThlM2E0YTA3OTE0MzNhZjU4YTYzIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogRnJpLCAxOCBOb3YgMjAyMiAwNzoxOTozMCArMDEwMApTdWJqZWN0OiBbUEFUQ0hd IEZpeCB0ZXh0IGFsaWdubWVudCBpbiBhbiBleGFtcGxlCgotLS0KIGRvYy9zcmMvc2dtbC9wbHBn c3FsLnNnbWwgfCAyICstCiAxIGZpbGUgY2hhbmdlZCwgMSBpbnNlcnRpb24oKyksIDEgZGVsZXRp b24oLSkKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvcGxwZ3NxbC5zZ21sIGIvZG9jL3NyYy9z Z21sL3BscGdzcWwuc2dtbAppbmRleCBkODVmODliZjMwLi5lODBhYjI5MTNmIDEwMDY0NAotLS0g YS9kb2Mvc3JjL3NnbWwvcGxwZ3NxbC5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9wbHBnc3FsLnNn bWwKQEAgLTQzMDEsNyArNDMwMSw3IEBAIENSRUFURSBUQUJMRSBlbXBfYXVkaXQoCiAgICAgc3Rh bXAgICAgICAgICAgICAgdGltZXN0YW1wIE5PVCBOVUxMLAogICAgIHVzZXJpZCAgICAgICAgICAg IHRleHQgICAgICBOT1QgTlVMTCwKICAgICBlbXBuYW1lICAgICAgICAgICB0ZXh0ICAgICAgTk9U IE5VTEwsCi0gICAgc2FsYXJ5IGludGVnZXIKKyAgICBzYWxhcnkgICAgICAgICAgICBpbnRlZ2Vy CiApOwogCiBDUkVBVEUgT1IgUkVQTEFDRSBGVU5DVElPTiBwcm9jZXNzX2VtcF9hdWRpdCgpIFJF VFVSTlMgVFJJR0dFUiBBUyAkZW1wX2F1ZGl0JAotLSAKMi4zOC4xCgo= --=-iPyTLBfyRW09EnB80u4Z--