Default setting of NAMEDATALEN

From: Jochen Westland <jochen(dot)westland(at)invigo(dot)de>
To: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Default setting of NAMEDATALEN
Date: 2002-10-14 15:40:56
Message-ID: 01C273A8.DA59BF90.jochen.westland@invigo.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-10-14 15:58:27 Re: droped out precise time calculations in src/interfaces/libpq/fe-connect.c
Previous Message Tom Lane 2002-10-14 15:19:45 Re: droped out precise time calculations in src/interfaces/libpq/fe-connect.c