doc: create table improvements

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема doc: create table improvements
Дата
Msg-id CAKFQuwYfMV-2SdrP-umr5SVNSqTn378BUvHsebetp5=DhT494w@mail.gmail.com
обсуждение исходный текст
Ответы Re: doc: create table improvements  (Peter Eisentraut <peter@eisentraut.org>)
Список pgsql-hackers
Hey,

The attached patch addresses four somewhat related aspects of the create table reference page that bother me.

This got started with Bug# 15954 [1] (unlogged on a partitioned table doesn't make sense) and I've added a paragraph under "unlogged" to address it.

While doing that, it seemed desirable to explicitly frame up both temporary and unlogged as being "persistence modes" so I added a mention of both in the description.  Additionally, it seemed appropriate to do so immediately after the opening paragraph since the existing second paragraph goes immediately into talking about temporary tables and schemas.  I figured a link to the reliability chapter where one learns about WAL and why/how these alternative persistence modes exist is worthwhile. (I added a missing comma to the first sentence while I was in the area)

Third, I've had a long-standing annoyance regarding the excessive length of the CREATE line of each of the create table syntax blocks.  Replacing the syntax for the persistence modes with a named placeholder introduces structure and clarity while reducing the length of the line nicely.

Finally, while fixing line lengths, the subsequent line (first form) for column specification is even more excessive.  Pulling out the column_storage syntax into a named reference nicely cleans this line up.

David J.

P.S. I didn't go into depth on the fact the persistence options are not inherited/copied/like-able; so for now the fact they are not so is discovered by their omission when discussing those topics.
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Nathan Bossart
Дата:
Сообщение: Re: improve performance of pg_dump --binary-upgrade
Следующее
От: Robert Haas
Дата:
Сообщение: Re: post-freeze damage control