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