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