> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Allan Kamau > Sent: Friday, November 20, 2009 1:42 AM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: Allowing for longer table names (>64 > characters) > > On Fri, Nov 20, 2009 at 11:21 AM, A. Kretschmer > <andreas.kretschmer@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) 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@xxxxxxxxxxxxxx) To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general I can't imagine naming a table like you describe. A "users" table name is pretty clear. I would love to see an example of this. You should probably get "un-caught-up" in using this concept. Perhaps reading about an existing model (ie; hungarian notation) and tweak it to fit your needs. But hey..maybe you're on to a new thing. Bret -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
