Support #8354
closed
Sardara Database - extend maximum characters in labels
100%
Description
I would like to extend the maximum number of characters for labels (table names) in the PostgreSQL Sardara database (sardara_world on db-tuna.d4science.org)
As explained here: https://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
"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."
Could you extend NAMEDATALEN to 100 ?
Thanks,
Paul
Updated by Massimiliano Assante almost 8 years ago
- Assignee changed from Massimiliano Assante to Lucio Lelii
reassigning the ticket to Lucio who has more expertise in this type of tasks
Updated by Paul Taconet almost 8 years ago
Hi Lucio,
Did you have the time to check this ticket?
Cheers,
Updated by Lucio Lelii almost 8 years ago
- Assignee changed from Lucio Lelii to Massimiliano Assante
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.
Updated by Massimiliano Assante almost 8 years ago
- Status changed from New to In Progress
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?
Updated by Andrea Dell'Amico almost 8 years ago
Massimiliano Assante wrote:
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?
You have to change that value in the include file and then recompile. I don't think we can afford that, we should repackage postgres each time we need to update to fix a security vulnerability.
Updated by Massimiliano Assante almost 8 years ago
- Status changed from In Progress to Closed
- % Done changed from 0 to 100
So I was remembering well, unfortunately Paul. Sorry, we cannot support your request.
