From: Ansley, Michael <Michael.Ansley@intec.co.za>
To: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: RE: pgsql-sql-digest V1 #276
Date: Wed, 30 Jun 1999 09:24:56 +0200
Message-ID: <1BF7C7482189D211B03F00805F8527F70ECFD1@S-NATH-EXCH2> (raw)
You need to make sure that the client tool that you are using is aware of
the fact that you want this to be a pass-through query. If not, then ODBC
will try to evaluate the query, instead of passing it through to the dbms.
If you are using ADO or something, set the QueryType (or something) property
to SQLPassThrough. I can't remember the exact names and properties, but
look in the VB or ADO help for SQLPassThrough, or CursorType, and read up.
The main thing is to get ODBC to just hand the query over to the dbms
without trying to evaluate it.
MikeA
>> Hi
>>
>> I'm running PostgreSQL v6.4.2 on Red Hat Linux 6.0. I use it
>> on a Windows NT
>> server 4.0 with service pack 5 through ODBC calls; the ODBC
>> driver is the
>> one from Insight Distributions System, v6.40.00.06. The IP
>> address of the NT
>> machine is specified as "trust" in pg_hba.conf.
>>
>> I've been playing a bit with PL/pgSQL ... I find it quite
>> usefull. But I
>> have one problem: The functions I create seem to be
>> accessible only from
>> within the psql utility. When I try to run a query from the
>> network, I get
>> an ODBC error stating that the function doesn't exist.
>> Queries not involving
>> user-defined functions run fine.
>>
>> Here is one of these functions:
.
.
.
>>
>> appears in the list, but the query fails. Anyone has an idea?
>>
>> Thanks,
>>
>> Nicolas Cadou
>>
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: Michael.Ansley@intec.co.za
Subject: Re: pgsql-sql-digest V1 #276
In-Reply-To: <1BF7C7482189D211B03F00805F8527F70ECFD1@S-NATH-EXCH2>
References: <1BF7C7482189D211B03F00805F8527F70ECFD1@S-NATH-EXCH2>
* 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