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
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 |