From: Adam Rossi <adam.rossi@platinumsolutions.com>
To: pgsql-interfaces@postgresql.org
Subject: ODBC longvarchar error - why does this not work?
Date: Fri, 16 Jun 2000 14:30:13 -0400
Message-ID: <06ae01bfd7c0$e97b7c60$0200a8c0@RSGROUP> (raw)
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
errors.
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: adam.rossi@platinumsolutions.com
Subject: Re: ODBC longvarchar error - why does this not work?
In-Reply-To: <06ae01bfd7c0$e97b7c60$0200a8c0@RSGROUP>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox