identifier will be truncated

On 2/8/21 8:39 AM, Joao Miguel Ferreira wrote:

Hello all,

I'm running unit/integration tests on a pg based application. I recently
started getting the following indication on the test suite pg client:

NOTICE:  identifier
"y1972_1004_vat_periodic_declaration_suppliers_lines_dupl_c24_liq" will
be truncated to
"y1972_1004_vat_periodic_declaration_suppliers_lines_dupl_c24_li"

Please advise on what I should do about it or if this might be a
potential problem that I should address.

https://www.postgresql.org/docs/12/sql-syntax-lexical.html

"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."

Thank you
Joao

--
Adrian Klaver
adrian.klaver@aklaver.com

Hi Joao,

On 08. Feb, 2021, at 17:39, Joao Miguel Ferreira <joao.miguel.c.ferreira@gmail.com> wrote:

NOTICE: identifier "y1972_1004_vat_periodic_declaration_suppliers_lines_dupl_c24_liq" will be truncated to "y1972_1004_vat_periodic_declaration_suppliers_lines_dupl_c24_li"

Please advise on what I should do about it or if this might be a potential problem that I should address.

this is an indication that your object name is longer than 63 characters, which is a hard coded limit.

You have two options:

a) compile the PostgreSQL software from source and increase that limit (which I wouldn't recommend), or

b) use shorter object names (table-, view-, sequence-, column-, whatever names) with a maximum length of 63 characters.

Cheers,
Paul