I am getting below error as I use drizzle, these are repeating too often. I am using postgres driver
{
severity_local: 'NOTICE',
severity: 'NOTICE',
code: '42622',
message: 'identifier "person_personRelationships_relatedCommonPerson_commonPersonTranslations" will be truncated to "person_personRelationships_relatedCommonPerson_commonPersonTran"',
file: 'scansup.c',
line: '102',
routine: 'truncate_identifier'
}
Is this something to be concerned about. What if there are two different things that get truncated to same.
I am using relational queries here.
6 Replies
how did you solved it? i was looking into specifying my own indentifier but could not find anything...
I could not solve it, it's not troubling me with anything now, it would be great if we drizzle did something about this.
This is coming from the driver.
See here how somebody here disabled it: https://discord.com/channels/1043890932593987624/1144213507424923800
ty @Angelelz disabling the notice does not really solve it bc this specific notice messes up with the FK constraints.
For example, a FK constraint not being added with no error, so you think everything is fine.. but in reality a constraint was not added to the table.
I think the drizzle team is working on a way to specify the constraint index names which would fix this. (https://ptb.discord.com/channels/1043890932593987624/1168063086146617454/1168065522412298292)
For now i just renamed the tables to a shorter name
Well, from the notice that you provided, it looks like the foreign key is being added. It's just the name that gets truncated
I don't see likely that you'll have name collisions, because the names have to be unique in the context of the table
yes.. it seems that way. however when I got to check the table structure the FK was not added
no worries tho. Ill just wait for a way for us to add custom fk names. After changing the table names to shorter ones its all fixed now. 🙂