Thread: Name limit to 31 chars

Name limit to 31 chars

From
Oscar Pérez
Date:
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

From
Einar Karttunen
Date:
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