Thread: Need to include the length of trigger names

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

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

Tom Lane wrote:
>
> 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.

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