Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jC55h-0002fw-1A for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Mar 2020 17:24:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jC55e-0006hy-Ny for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Mar 2020 17:24:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jC55e-0006hp-BV for pgsql-hackers@lists.postgresql.org; Wed, 11 Mar 2020 17:24:18 +0000 Received: from mail-oi1-x22c.google.com ([2607:f8b0:4864:20::22c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jC55Y-0004h3-8Y for pgsql-hackers@postgresql.org; Wed, 11 Mar 2020 17:24:16 +0000 Received: by mail-oi1-x22c.google.com with SMTP id p125so2645970oif.10 for ; Wed, 11 Mar 2020 10:24:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=esDv8jY90KIKt1kA99N2juUU1ipPTnPKJXd1cFoTu0Y=; b=OzoMudfjBvkG/tfF2fuf590O0kccGkPjMIDMwMvVFrllGHjILTaItYHoKjemmtdy6D GwcSDV3kg3GJOldUBE8QeiBH/jLMgSk4F1SOHhtDH0elM+BK/X51gaaAWB+XHTEGsgzb oGl2Yvm0KVuSWr2/V4i1Pe+xXosv2DfGUBlUFY3KJ1R9A+2udDVyrE7OdiFkrmQmun2x aq0Zzl8+xkJa32PQ2JSNQ362Wkj2nzjdUI0/QMN1VKf+jzCtXFJMGm34QJCkbdoRkrYw y1LMle7KgjeQ8VjMdioIZqYQ4/Rocsc1rzDaXBQnhUVNSZZmGHDfPMXhcmo3E/mvqVec C5Bw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=esDv8jY90KIKt1kA99N2juUU1ipPTnPKJXd1cFoTu0Y=; b=TAzmACRzWsy70CtfjePeXxvVRDxAqEeZzo4ua1ibxSSvyA3Gi3GCwEq81SgFu6SePX vwTf0v/GcDczRm9J+G5kXdwu8S3b5Hn3aFTOYrwzktvyuez91mY3E6ggmiApgScZtSi2 C0qbKQMgdvxRSbALheioIjUOlp3cIJWpngjrOIMHz8gaUsrRq9BjrClwy7x1KX8vtnYp VQ1HBezC+KHh7Oso40qwLy6x/+NPeVkNVcfI+ucKyv1g4VeeTzWEnB1dnLrlhsqQxmJu 1gKalnaUizkk8vx2V/w5uZqBZtiqDG29Uq5npZusQ7lXiWuh5a8gwGpz3jrTUtKz2jF0 WApw== X-Gm-Message-State: ANhLgQ3atXb1MxWadSNr2lwm6SXsq8rZvk8JWqAZhqX11LvOhrLjzcBz ENMCstDpAf1Onyx14gpHBxnFm0HfieeY3bA8040= X-Google-Smtp-Source: ADFU+vsCRwf1XnFoLygJ8gR9owp7OhmQUdUHZ1jq9L/poSDe1c9nb5oNSoWsdBn1K2SCJOkI3M476cUAmgPxvuPuDZ4= X-Received: by 2002:aca:dc8b:: with SMTP id t133mr2757640oig.98.1583947451433; Wed, 11 Mar 2020 10:24:11 -0700 (PDT) MIME-Version: 1.0 References: <20191125075507.GH99720@paquier.xyz> <763ae38f-599b-cfb9-0447-337649dfb017@purtz.de> In-Reply-To: <763ae38f-599b-cfb9-0447-337649dfb017@purtz.de> From: Corey Huinker Date: Wed, 11 Mar 2020 13:23:57 -0400 Message-ID: Subject: Re: Add A Glossary To: =?UTF-8?Q?J=C3=BCrgen_Purtz?= Cc: Roger Harkavy , pgsql-hackers@postgresql.org, Fabien COELHO , Michael Paquier Content-Type: multipart/alternative; boundary="0000000000002f850d05a09781fb" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000002f850d05a09781fb Content-Type: text/plain; charset="UTF-8" > > It will be helpful for diff-ing to restrict the length of lines in the > SGML files to 71 characters (as usual). I did it that way for the following reasons 1. It aids grep-ability 2. The committers seem to be moving towards that for SQL strings, mostly for reason #1 3. I recall that the code is put through a linter as one of the final steps before release, I assumed that the SGML gets the same. 4. Even if #3 is false, its easy enough to do manually for me to do for this one file once we've settled on the text of the definitions. As for the changes, most things seem fine, I specifically like: * Checkpoint - looks good * yes, PGDATA should have been a literal * Partition - the a/b split works for me * Unlogged - it reads better I'm not so sure on / responses to your ???s: * The statement that names of schema objects are unique isn't *strictly* true, just *mostly* true. Take the case of a unique constraints. The constraint has a name and the unique index has the same name, to the point where adding a unique constraint using an existing index renames that index to conform to the constraint name. * Serializable "other way around" question - It's both. Outside the transaction you can't see changes made inside another transaction (though you can be blocked by them), and inside serializable you can't see any changes made since you started. Does that make sense? Were you asking a different question? * Transaction - yes, all those things could be "visible" or they could be "side effects". It may be best to leave the over-simplified definition in place, and add a "For more information see <> --0000000000002f850d05a09781fb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
It will be helpful for diff-ing to restrict the length o= f lines in the
SGML files to 71 characters (as usual).

I d= id it that way for the following reasons
1. It aids grep-ability<= /div>
2. The committers seem to be moving towards that for SQL strings,= mostly for reason #1
3. I recall that the code is put through a linter = as one of the final steps before release, I assumed that the SGML gets the = same.
4. Even if #3 is false, its easy enough to do manually for = me to do for this one file once we've settled on the text of the defini= tions.

As for the changes, most things seem fine, = I specifically like:
* Checkpoint - looks good
* yes, P= GDATA should have been a literal
* Partition - the a/b split works for m= e
* Unlogged - it reads better

I'm not so sure on / re= sponses to your ???s:
* The statement that names of schema objects are u= nique isn't strictly=C2=A0true, just mostly=C2=A0true. Ta= ke the case of a unique constraints. The constraint has a name and the uniq= ue index has the same name, to the point where adding a unique constraint u= sing an existing index renames that index to conform to the constraint name= .
* Serializable "other way around" question - It's= both. Outside the transaction you can't see changes made inside anothe= r transaction (though you can be blocked by them), and inside serializable = you can't see any changes made since you started. Does that make sense?= Were you asking a different question?
* Transaction - yes, all t= hose things could be "visible" or they could be "side effect= s". It may be best to leave the over-simplified definition in place, a= nd add a "For more information see <<linref to tutorial-transact= ions>>
--0000000000002f850d05a09781fb--