Re: Allowing for longer table names (>64 characters)

On Fri, Nov 20, 2009 at 11:21 AM, A. Kretschmer
<andreas(dot)kretschmer(at)schollglas(dot)com> wrote:
> In response to Allan Kamau :
>> Hi all,
>> I would like to increase the database objects names limit from 64
>> characters to may be 128 characters to avoid name conflicts after
>> truncation of long table/sequence names.
>> I have seen a solution to this sometime back which includes (building
>> from source) modifying a header file then recompiling, but I now
>> cannot find this information.
>
> In the source-tree, src/include/pg_config_manual.h , change NAMEDATALEN.
> But i think it's a bad idea ... 64 characters are enough for me.
>
>
> Andreas
> --
> Andreas Kretschmer
> Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
> GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Thanks Andreas, I too agree it may not be a good idea to have long for
various reasons including porting/upgrading issues and so on, as I
have many tables, I seem to have been caught up in describing table
functionality in the table name :-)

Allan.