Received: from sss.pgh.pa.us ([192.204.191.242])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id fBHFA5m69046;
	Mon, 17 Dec 2001 10:10:06 -0500 (EST)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fBHFA9i04310;
	Mon, 17 Dec 2001 10:10:09 -0500 (EST)
To: Justin Clift <justin@postgresql.org>
cc: pgsql-docs@postgresql.org
Subject: Re: Need to include the length of trigger names 
In-reply-to: <3C1D9DE1.289D1D32@postgresql.org> 
References: <3C1D9DE1.289D1D32@postgresql.org>
Comments: In-reply-to Justin Clift <justin@postgresql.org>
	message dated "Mon, 17 Dec 2001 18:25:21 +1100"
Date: Mon, 17 Dec 2001 10:10:09 -0500
Message-ID: <4307.1008601809@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200112/6
X-Sequence-Number: 1187

Justin Clift <justin@postgresql.org> 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.

			regards, tom lane