Default setting of NAMEDATALEN
От | Jochen Westland |
---|---|
Тема | Default setting of NAMEDATALEN |
Дата | |
Msg-id | 01C273A8.DA59BF90.jochen.westland@invigo.de обсуждение исходный текст |
Ответы |
Re: Default setting of NAMEDATALEN
|
Список | pgsql-hackers |
Hi there, my question is short, quite simple and definately a hacker thing (hopefully). FIRST of all: POSTGRES is a great database system! Thanks a lot for your perfect work. Now my Question: Wouldn't it be possible to change the default setting of NAMEDATALEN in all distributions to a higher value, lets say 128? Or a bit better: Get the length of NAMEDATALEN by a select statement for all applications using postgres beeing a bit more flexible? Reason: I think that there are several systems out there running with higher values to make reading (and understanding) table- and rownames a bit easier. All linux packages are compiled with that standard value as well as all applications (like psqlodbc eg) are actually designed - also by default - for a length of 32, so changing NAMEDATALEN and recompiling postgreql does'nt solve anything, afterwards you have to contact odbc-developers, tool-developers and so on for a hint how to make their systems cope with that new value. Regarding decreasing cpu-speed and increasing hardware cost, shouldn't it be possible to set a higher value for NAMEDATALEN by default, so that especially complex postgres-databases can be developed on a standard compilation, and the development of applications would be made a bit more comfortable? Regards and thanks for your time jochen
В списке pgsql-hackers по дате отправления: