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

ODBC longvarchar error - why does this not work?

From: "Adam Rossi" <adam(dot)rossi(at)platinumsolutions(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: ODBC longvarchar error - why does this not work?
Date: 2000-06-16 18:30:13
Message-ID: 06ae01bfd7c0$e97b7c60$0200a8c0@RSGROUP (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
I am trying to use Visio enterprise in conjunction with PostgreSQL 7.0.2 via
the ODBC driver (6.5). It works perfectly except for one small issue -
longvarchar types do not work. I have searched the archives and tried a
number of different ODBC driver settings (unknown as LONGVARCHAR, TEXT as
LONGVACHAR, PARSE STATEMENTS, etc) with no success. The relevant portion of
the ODBC log is included below. As you can see, I have two fields defined as
LONGVARCHAR. Tables without longvarchar fields are created without any

conn=131151048, query='BEGIN'
conn=131151048, query='create table practice (    practice_id INTEGER not
null,   practice_des LONGVARCHAR,   practice_inst LONGVARCHAR,   pop_up_def
VARCHAR(250), constraint practice_pk primary key (practice_id) )    '
ERROR from backend during send_query: 'ERROR:  Unable to locate type name
'longvarchar' in catalog'

Thanks for your help.

- Adam

pgsql-interfaces by date

Next:From: John CampbellDate: 2000-06-16 18:39:56
Subject: pgaccess deletes function in database
Previous:From: Tom LaneDate: 2000-06-16 18:23:37
Subject: Re: [PATCH] Datatype of OID should be VARBINARY, not INT

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