Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-07-17 Thread David Rowley
On Thu, 18 Jul 2024 at 17:18, Tom Lane wrote: > Yeah. I've found this new feature useful multiple times already, > but the '#' icon is as non-mnemonic and unobvious as could possibly > be. OTOH, I don't know of a standard icon for this feature. I also find it useful and certainly don't want it

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-07-17 Thread David G. Johnston
On Wednesday, July 17, 2024, Tom Lane wrote: > David Rowley writes: > > On Thu, 18 Jul 2024 at 16:55, Muhammad Ikram wrote: > >> when we hover over Table Basics, it shows # sign postfixed. I think it > needs to be removed > > > In [1], there was some talk about using another more suitable > > c

Re: Column data type in doc example may be changed to VARCHAR from TEXT

2024-07-17 Thread Tom Lane
"David G. Johnston" writes: > On Wednesday, July 17, 2024, Muhammad Ikram wrote: >> IMHO, a minor issue in the doc. As a good practice we use TEXT data type >> when we expect longer text e.g. comments, doc kind of columns. > Who is we in this conversation? If it’s the documentation please refer

Re: Column data type in doc example may be changed to VARCHAR from TEXT

2024-07-17 Thread Muhammad Ikram
Thanks David for clarifying. I am coming from an Oracle background, so there we(developers) mostly use CHAR or VARCHAR2 data types for such identifiers instead of CLOB. Sorry for my naiveness about PostgreSQL doc practices. Regards, Muhammad Ikram Bitnine global. On Thu, Jul 18, 2024 at 10:17 AM

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-07-17 Thread Tom Lane
David Rowley writes: > On Thu, 18 Jul 2024 at 16:55, Muhammad Ikram wrote: >> when we hover over Table Basics, it shows # sign postfixed. I think it needs >> to be removed > In [1], there was some talk about using another more suitable > character. If the purpose of the '#' isn't obvious, then

Re: Column data type in doc example may be changed to VARCHAR from TEXT

2024-07-17 Thread David G. Johnston
On Wednesday, July 17, 2024, Muhammad Ikram wrote: > > > IMHO, a minor issue in the doc. As a good practice we use TEXT data type > when we expect longer text e.g. comments, doc kind of columns. > Who is we in this conversation? If it’s the documentation please reference existing work. Text is

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-07-17 Thread Kashif Zeeshan
Hi David Thanks for the clarification. Regards Kashif Zeeshan On Thu, Jul 18, 2024 at 10:07 AM David Rowley wrote: > On Thu, 18 Jul 2024 at 16:55, Muhammad Ikram wrote: > > 5.1. Table Basics # > > > > when we hover over Table Basics, it shows # sign postfixed. I think it > needs to be removed

Column data type in doc example may be changed to VARCHAR from TEXT

2024-07-17 Thread Muhammad Ikram
Hi, IMHO, a minor issue in the doc. As a good practice we use TEXT data type when we expect longer text e.g. comments, doc kind of columns. For columns where we know what can be a maximum Text size though variable, we use VARCHAR to limit accidental long text or for other worthy reasons. Followin

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-07-17 Thread David Rowley
On Thu, 18 Jul 2024 at 16:55, Muhammad Ikram wrote: > 5.1. Table Basics # > > when we hover over Table Basics, it shows # sign postfixed. I think it needs > to be removed Those are meant to be there. They allow you to copy a URL directly to that doc section. In [1], there was some talk about us

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-07-17 Thread David G. Johnston
On Wednesday, July 17, 2024, Kashif Zeeshan wrote: > > > I have checked other pages too and the issue is only with this page. > There are like thousands of them… https://www.postgresql.org/docs/current/ddl-generated-columns.html#DDL-GENERATED-COLUMNS David J.

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-07-17 Thread David G. Johnston
On Wednesday, July 17, 2024, Muhammad Ikram wrote: > > Hi, > > On page > > https://www.postgresql.org/docs/devel/ddl-basics.html > > 5.1. Table Basics # > > > when we hover over Table Basics, it shows # sign postfixed. I think it

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-07-17 Thread Kashif Zeeshan
Hi I have checked other pages too and the issue is only with this page. Regards Kashif Zeeshan On Thu, Jul 18, 2024 at 9:55 AM Muhammad Ikram wrote: > > Hi, > > On page > > https://www.postgresql.org/docs/devel/ddl-basics.html > > 5.1. Table Basics # >

A minor bug in doc. Hovering over heading shows # besides it.

2024-07-17 Thread Muhammad Ikram
Hi, On page https://www.postgresql.org/docs/devel/ddl-basics.html 5.1. Table Basics # when we hover over Table Basics, it shows # sign postfixed. I think it needs to be removed -- Regards, Muhammad Ikram Bitnine Global

Re: 13.2.1. Read Committed Isolation Level

2024-07-17 Thread Василий Лебедев
Thank you for the response. Can I clarify if I understood the essence correctly? It turns out that despite the Read Committed isolation level, due to the presence of a unique index, which has an independent isolation mechanism, a transaction can "know" that a parallel transaction has performed an i

Re: Re: Mismatch for connection key/value pair between documentation and code?

2024-07-17 Thread 周志勤
Hi David, Thanks for your clarification. Best regards, Joe joe.z...@dualhelios.com From: David G. Johnston Date: 2024-07-16 22:20 To: joe.z...@dualhelios.com; pgsql-docs@lists.postgresql.org Subject: Re: Mismatch for connection key/value pair between documentation and code? On Monday, July