Configuring postgresql build to handle long names - Mailing list pgsql-general

From Fredrick Paul Eisele
Subject Configuring postgresql build to handle long names
Date
Msg-id 3DCA9B11.2070309@netarx.com
Whole thread Raw
Responses Re: Configuring postgresql build to handle long names  (Benjamin Scherrey <scherrey@proteus-tech.com>)
List pgsql-general
We have a need for long table names (and long column names).
A table name of 127 (base setting is 31) should be sufficient.

I updated
"postgresql/dist/postgresql-7.2.3/src/interfaces/odbc/psqlodbc.h" as
follows...

#define MAX_TABLE_LEN       128
#define MAX_COLUMN_LEN        128

#define NAME_FIELD_SIZE       128 /* size of name fields */

If I understand correctly that header is used for the command line
interface.


The real change is to
"/aegis/postgresql/dist/postgresql-7.2.3/src/include/postgres_ext.h".

#define NAMEDATALEN 128   /* default is 32 */

Is this correct place to make the change?
Thanks.


pgsql-general by date:

Previous
From: "peter"
Date:
Subject: dates
Next
From: Miles Elam
Date:
Subject: two table foreign keys