Re: Problem in using PostgreSQL ODBC driver with VBA

From: "Arnaud L(dot)" <arnaud(dot)listes(at)codata(dot)eu>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Problem in using PostgreSQL ODBC driver with VBA
Date: 2016-11-10 12:48:59
Message-ID: 3060c627-b416-a491-7189-234cd72abad2@codata.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Le 10/11/2016 à 10:46, Vincenzo Turturro a écrit :
> Il 10/11/2016 09:42, Arnaud L. ha scritto:
>> I've been using the solution from this post for a long time and never
>> had any problem :
>> http://www.postgresonline.com/journal/index.php?url=archives/24-Using-MS-Access-with-PostgreSQL.html
>>
>> See the section "dealing with boolean".
>> I like the fact that function is written in pure SQL.
>>
>
> I have tried the solution you suggest, but without success.
> I used the SQL statements provided in the post, but the problem wasn't
> solved.
> Maybe I missed something that is not mentioned in the post because it's
> obvious for PG users ?
> Keep in mind I'm a newby in PG !

I'm no PG guru either, so the only "obvious" thing I can think of is
that the operators and functions you are creating are not in your search
path when you connect through ODBC.

So I guess the best for you would be to create them in the public
schema, and to check in your ODBC connection that the public schema is
in your search path. (a simple "show search_path;" query)

Then through ODBC, what do you get when you try to directly call
inttobool() or notinttobool ? Do these functions exist and work as
expected ?
i.e. select inttobool(-1,true);
And what about a direct call to the operators ?
i.e. what do you have when you call
select 1::int4 <> false::boolean ;
and what about the schema-qualified version ?
select 1::int4 operator(public.<>) false::boolean;

Regards

--
Arnaud

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Nathan Kendall 2016-11-10 14:45:11 Daylight saving time rules being applied to DateTimes that don't have a timezone
Previous Message Vincenzo Turturro 2016-11-10 09:46:19 Re: Problem in using PostgreSQL ODBC driver with VBA