Обсуждение: PostgreSQL's Identifier Length

Поиск
Список
Период
Сортировка

PostgreSQL's Identifier Length

От
Amine Tengilimoglu
Дата:
Hello to everyone;

I get an error like this: ATTENTION: The identifier "XXXxxx" will be truncated to "XXX.
Is there a simple way to fix this error without any changes in the source code (I'm talking about NAMEDATALEN)?  I guess there is not but I still wanted to ask..

 Has anyone experienced this?

thanks in advance..

Re: PostgreSQL's Identifier Length

От
Magnus Hagander
Дата:


On Fri, Oct 2, 2020 at 3:00 PM Amine Tengilimoglu <aminetengilimoglu@gmail.com> wrote:
Hello to everyone;

I get an error like this: ATTENTION: The identifier "XXXxxx" will be truncated to "XXX.
Is there a simple way to fix this error without any changes in the source code (I'm talking about NAMEDATALEN)?  I guess there is not but I still wanted to ask..


You need to recompile PostgreSQL to change NAMEDATALEN (and also re-initialize your database). 

--

Re: PostgreSQL's Identifier Length

От
Amine Tengilimoglu
Дата:
Recompiling PostgreSQL  source code and re-initializing cluster are not suitable for the current situation. 

Thank you.

Magnus Hagander <magnus@hagander.net>, 2 Eki 2020 Cum, 16:04 tarihinde şunu yazdı:


On Fri, Oct 2, 2020 at 3:00 PM Amine Tengilimoglu <aminetengilimoglu@gmail.com> wrote:
Hello to everyone;

I get an error like this: ATTENTION: The identifier "XXXxxx" will be truncated to "XXX.
Is there a simple way to fix this error without any changes in the source code (I'm talking about NAMEDATALEN)?  I guess there is not but I still wanted to ask..


You need to recompile PostgreSQL to change NAMEDATALEN (and also re-initialize your database). 

--