D4Science Infrastructure

reassigning the ticket to Lucio who has more expertise in this type of tasks

Sorry Paul but I know nothing about the sardara DB.
I'm reassigning the ticket to Massimiliano hoping he knows who is in charge of this db.

Well, i don't think that one should know the sardara DB schema to do the job. If I understand correctly Paul is asking to increase the maximum number of characters for labels (table names) in the PostgreSQL instance hosting this DB.

To do so, he suggested us to look at the NAMEDATALEN system conf:

"The system uses no more than NAMEDATALEN-1 bytes of an identifier; longer names can be written in commands, but they will be truncated. By default, NAMEDATALEN is 64 so the maximum identifier length is 63 bytes. If this limit is problematic, it can be raised by changing the NAMEDATALEN constant in src/include/pg_config_manual.h."

is changing the NAMEDATALEN constant in src/include/pg_config_manual.h. enough @paul.taconet@ird.fr ? 'cause the last time (more than 10 years ago actually) i looked into this things you had to recompile postgres for these changings (reason why I asked Lucio to look for this issue as he's very skilled with postgres)

Anyway, Paul, you sure changing the property would suffice?

So I was remembering well, unfortunately Paul. Sorry, we cannot support your request.