Re: HELP!! #DEFINE NAMEDATALEN 128 in postgres_ext.h causes

> Jochen Westland wrote:
>
> Hi there,
> i am really depressed, and maybe i can get some help from you.
>
> my problem:
> i really urgently need to get a postgres database supporting
> longer table and columnnames working with odbc (and pgadmin),
> and i fail, i fail, i fail ... and i continue to fail ...
>
> ok, system first:
> ***************************************
> Database server:
> mandrake linux 8.1
> Postgres 7.2.1 properly installed from src-rpm
>
> i changed the progres_ext.h as mentioned in maik header to
> support longer identifiers. (#DEFINE NAMEDATALEN 128)

Setting postgres_ext.h is meanless for the ODBC driver.
How can(Why should) the driver see the source file on your
server machine ? The current odbc driver only can handle
NAMEDATALEN=32 databases.
BTW can you compile the driver by youself ?
If so, change MAX_TABLE_LEN and MAX_COLUMN_NAME in
src/interfaces/odbc/psqlodbc.h and build the driver
by youself.

regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/