Received: from mta04.mail.mel.aone.net.au (mta04.mail.au.uu.net [203.2.192.84]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBHFSum69887 for ; Mon, 17 Dec 2001 10:28:57 -0500 (EST) (envelope-from justin@postgresql.org) Received: from postgresql.org ([63.34.218.88]) by mta04.mail.mel.aone.net.au with ESMTP id <20011217152857.DNWR24966.mta04.mail.mel.aone.net.au@postgresql.org>; Tue, 18 Dec 2001 02:28:57 +1100 Message-ID: <3C1E0ECD.C416E046@postgresql.org> Date: Tue, 18 Dec 2001 02:27:09 +1100 From: Justin Clift X-Mailer: Mozilla 4.78 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: pgsql-docs@postgresql.org Subject: Re: Need to include the length of trigger names References: <3C1D9DE1.289D1D32@postgresql.org> <4307.1008601809@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200112/7 X-Sequence-Number: 1188 Tom Lane wrote: > > Justin Clift writes: > > I was just looking at the Developer Docs for the "CREATE CONSTRAINT > > TRIGGER" command in the SQL Commands reference section. Noticed it > > doesn't include a mention of the maximum length of the trigger "name" > > field (31 characters). I reckon this should be mentioned, > > It's the same as every other name. Do you want us to repeat the whole > of > http://developer.postgresql.org/docs/postgres/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS > in every CREATE command's reference page? I don't think that'd be > an improvement. No need for overkill. Its just nice to mention the maximum length of the name in the reference page for the commands. :) Regards and best wishes, Justin Clift > > regards, tom lane -- "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