Thread: Sentence which needs updating in developer docs?

Sentence which needs updating in developer docs?

From
Justin Clift
Date:
Hi all,

In the SQL Commands Reference section of the development docs, for the
command "CREATE TABLE", it has the paragraph :

"A table cannot have more than 1600 columns. (In practice, the effective
limit is lower because of tuple-length constraints). A table cannot have
the same name as a system catalog table."

Is the "(In practice, the effective limit is lower because of
tuple-length constraints)" still correct?

Something minor, but still worth mentioning.

Regards and best wishes,

Justin Clift

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
     - Indira Gandhi

Re: Sentence which needs updating in developer docs?

From
Bruce Momjian
Date:
> Hi all,
>
> In the SQL Commands Reference section of the development docs, for the
> command "CREATE TABLE", it has the paragraph :
>
> "A table cannot have more than 1600 columns. (In practice, the effective
> limit is lower because of tuple-length constraints). A table cannot have
> the same name as a system catalog table."
>
> Is the "(In practice, the effective limit is lower because of
> tuple-length constraints)" still correct?
>
> Something minor, but still worth mentioning.

Yes, it is accurate.  Even though we have TOAST, we still need a place
to put the TOAST pointers.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026