Name limit to 31 chars

Started by Oscar Pérezabout 24 years ago2 messagesgeneral
Jump to latest
#1Oscar Pérez
javalotodo@iespana.es

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.

#2Einar Karttunen
ekarttun@cs.Helsinki.FI
In reply to: Oscar Pérez (#1)
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