Received: from candle.pha.pa.us (216-55-132-35.dialup.tnt01.san-diego.abac.net [216.55.132.35]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBI7GAm26936; Tue, 18 Dec 2001 02:16:10 -0500 (EST) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id fBI7G6l02057; Tue, 18 Dec 2001 02:16:06 -0500 (EST) From: Bruce Momjian Message-Id: <200112180716.fBI7G6l02057@candle.pha.pa.us> Subject: Re: Sentence which needs updating in developer docs? In-Reply-To: <3C1EE293.8A1BCBD0@postgresql.org> "from Justin Clift at Dec 18, 2001 05:30:43 pm" To: Justin Clift Date: Tue, 18 Dec 2001 02:16:05 -0500 (EST) CC: pgsql-docs@postgresql.org X-Mailer: ELM [version 2.4ME+ PL90 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200112/14 X-Sequence-Number: 1195 > 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