Need to include the length of trigger names

Started by Justin Cliftover 24 years ago3 messagesdocs
Jump to latest
#1Justin Clift
justin@postgresql.org

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Justin Clift (#1)
Re: Need to include the length of trigger names

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

#3Justin Clift
justin@postgresql.org
In reply to: Justin Clift (#1)
Re: Need to include the length of trigger names

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