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

Re: HELP!! #DEFINE NAMEDATALEN 128 in postgres_ext.h causes ODBC-ERROR(s) ??

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <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 ODBC-ERROR(s) ??
Date: 2002-07-08 15:54:10
Message-ID: D85C66DA59BA044EB96AB9683819CF61015133@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc

> -----Original Message-----
> From: Jochen Westland [mailto:jochen(dot)westland(at)invigo(dot)de] 
> Sent: 08 July 2002 16:33
> To: Dave Page
> Subject: AW: [ODBC] HELP!! #DEFINE NAMEDATALEN 128 in 
> postgres_ext.h causes ODBC-ERROR(s) ??
> 
> 
> hi dave,
> thanks a lot for your message, i'm looking forward for
> some good news :)
> 
> Just one thing, keep in mind that MSaccess fails as well as 
> pgadmin does, what makes me somehow sure, that that is a 
> odbc-driver problem in first instance... 

Yes, that's what I'm currently looking at. My tests give:

conn=51783144, query='SELECT c.oid, c.relname,
pg_get_userbyid(c.relowner) AS viewowner, c.relacl,
pg_get_viewdef(c.oid) AS definition FROM pg_class c WHERE
((c.relhasrules AND (EXISTS (SELECT r.rulename FROM pg_rewrite r WHERE
((r.ev_class = c.oid) AND (bpchar(r.ev_type) = '1'::bpchar))))) OR
(c.relkind = 'v'::"char")) AND relnamespace = 2200::oid ORDER BY
relname'
    [ fetched 8 rows ]
conn=51783144, query='SELECT relname, n_tup_ins, n_tup_upd, n_tup_del
FROM pg_stat_all_tables ORDER BY relname'
    [ fetched 107 rows ]
The 1th item was truncated
The buffer size = 33 and the value is
'this_is_a_table_with_a_bloody_great_big_long_name'
conn=51783144, PGAPI_Disconnect

In the commlog. The 'The 1th item was truncated' message comes from the
ODBC driver so I'll have to let someone who understands it's internal
more than me figure it out.

I *hope* that pgAdmin will work OK though when the driver does - there
are no set limits on string length in it so it *should* just work -
though it will probably slow down with very long names because it has to
encode them into upper case internally which doubles the length in
storage and slows things down a bit.

Regards, Dave.



pgsql-odbc by date

Next:From: Rod EnkeDate: 2002-07-09 00:48:55
Subject: Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion
Previous:From: Dave PageDate: 2002-07-08 15:09:41
Subject: Re: HELP!! #DEFINE NAMEDATALEN 128 in postgres_ext.h causes ODBC-ERROR(s) ??

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