> > It is only 27 characters in length!
>
>Exactly. This is a magic number.
No, it is not!
I have plenty of triggers with length = 31, without any issue.
http://wiki.ispirer.com/sqlways/interbase-firebird/identifiersKendall
On Thu, 2016-07-21 at 21:02 +, 'Leyne, Sean'
s...@broadviewsoftware.com [firebird-support] wrote:
>
>
> > > Any ideas?
> >
> > Shorten name of the PK_CUR_CASE_INV_NON_JUD_CNT constraint.
>
> Why? It is only 27 characters
21.07.2016 23:02, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
wrote:
> Why?
Just a shoot to darkness.
> It is only 27 characters in length!
Exactly. This is a magic number.
--
WBR, SD.
> > Any ideas?
>
>Shorten name of the PK_CUR_CASE_INV_NON_JUD_CNT constraint.
Why? It is only 27 characters in length!
> Trying to create a simple table and receive this error:
>
> unsuccessful metadata update
> cannot create index PK_CUR_CASE_INV_NON_JUD_CNT
> while executing:
> ALTER TABLE CUR_CASE_INV_NON_JUD_CNTY ADD CONSTRAINT
> FK_CUR_CASE_INV_RPT3
> FOREIGN KEY (REPORT_ID) REFERENCES CUR_CASE_INV_RPT
>
21.07.2016 22:40, 'stwizard' stwiz...@att.net [firebird-support] wrote:
> Any ideas?
Shorten name of the PK_CUR_CASE_INV_NON_JUD_CNT constraint.
--
WBR, SD.
++
Greetings All,
Firebird v2.5.4
Trying to create a simple table and receive this error:
unsuccessful metadata update
cannot create index PK_CUR_CASE_INV_NON_JUD_CNT
while executing:
ALTER TABLE CUR_CASE_INV_NON_JUD_CNTY ADD CONSTRAINT FK_CUR_CASE_INV_RPT3
FOREIGN KEY (REPORT_ID) R