Name limit to 31 chars
Started by Oscar Pérezabout 24 years ago2 messagesgeneral
Hello all,
Does anybody knows why table and field names are limited to 31 characters?
Is there any way of changing this?
Thank you in advance,
Kind regards,
Oscar.
Re: Name limit to 31 chars
On 01.02.02 12:54 +0100(+0000), Oscar P�rez wrote:
Does anybody knows why table and field names are limited to 31 characters?
Is there any way of changing this?
They are defined with the datatype name which is 32 bytes long.
There is a todo item that will increase the length:
From http://developer.postgresql.org/todo.php
Increase identifier length (NAMEDATALEN) if small performance hit,
perhaps to standard length of 128; change struct pgNotify to use pid
first, breaks notify API;
- Einar Karttunen