Skip site navigation (1) Skip section navigation (2)

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

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Jochen Westland <jochen(dot)westland(at)invigo(dot)de>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: HELP!! #DEFINE NAMEDATALEN 128 in postgres_ext.h causes
Date: 2002-07-09 07:05:52
Message-ID: 3D2A8B50.5AEF4059@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
> 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/



In response to

pgsql-odbc by date

Next:From: Preston LordDate: 2002-07-11 07:02:13
Subject: SuSE 8 pgsql install with unixodbc-gui?
Previous:From: Rod EnkeDate: 2002-07-09 00:48:55
Subject: Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group