On Fri, Nov 20, 2009 at 11:21 AM, A. Kretschmer <andreas.kretsch...@schollglas.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@postgresql.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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
