Thread: Configuring postgresql build to handle long names

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.

11/7/2002 11:55:45 AM, Fredrick Paul Eisele <phreed@netarx.com> wrote:
<snip>
>
>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.

Yep - that's the place to do it. Understand that your database server will not work correctly with
databases that were buily with a different value for NAMEDATALEN.

    good luck,

        Ben Scherrey

11/7/2002 11:55:45 AM, Fredrick Paul Eisele <phreed@netarx.com> wrote:
<snip>
>
>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.

Yep - that's the place to do it. Understand that your database server will not work correctly with
databases that were buily with a different value for NAMEDATALEN.

    good luck,

        Ben Scherrey