We have increased identifier length in 7.3, and in 7.2 you can alter include/postgres_ext.h NAMEDATALEN and recompile everything, including client applications/interfaces.
There is another limit, but one good thing is that in 7.2, I think, SM_DATABASE in src/include/pqcomm.h is already 64, so if you up the NAMEDATALEN, it should work. --------------------------------------------------------------------------- Ralf Praschak wrote: > hello list! > > i want to use database names that are longer than 32 characters. > i found that in pg_database the field datname is responsible for this > > how can i change the length? > i am using postgresql 7.2.1 > > greets > ralf praschak > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]