Received: from mta05bw.bigpond.com (mta05bw.bigpond.com [139.134.6.95]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBH7Uim65218 for ; Mon, 17 Dec 2001 02:30:45 -0500 (EST) (envelope-from justin@postgresql.org) Received: from postgresql.org ([144.135.24.69]) by mta05bw.bigpond.com (Netscape Messaging Server 4.15) with SMTP id GOH96M00.IA7 for ; Mon, 17 Dec 2001 17:37:34 +1000 Received: from CPE-144-132-71-99.vic.bigpond.net.au ([144.132.71.99]) by bwmam01.mailsvc.email.bigpond.com(MailRouter V3.0g 2/74025); 17 Dec 2001 17:30:43 Message-ID: <3C1D9DE1.289D1D32@postgresql.org> Date: Mon, 17 Dec 2001 18:25:21 +1100 From: Justin Clift X-Mailer: Mozilla 4.78 [en] (X11; U; Linux 2.4.8 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: Need to include the length of trigger names Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200112/5 X-Sequence-Number: 1186 Hi all, 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, and we should also probably mention it for other similar things in the SQL Commands reference section. 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