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