From: Jamie Walker <jamie@sagaxis.co.uk>
To: pgsql-interfaces@postgresql.org
Subject: Re: PostgreSQL -> ODBC -> MS ACCESS
Date: Fri, 8 Dec 2000 13:42:37 +0000
Message-ID: <7ff7eVANVOM6Ew2y@sagaxis.co.uk> (raw)
In-Reply-To: <3A30D821.6729EFE2@diedenoort.nl>
References: <3A30D821.6729EFE2@diedenoort.nl>
In article <3A30D821.6729EFE2@diedenoort.nl>, Frodo Larik
<Frodo.Larik@diedenoort.nl> writes
>
>ERROR: Unable to identify an operator '=' for types 'xid' and 'int4'
> You will have to retype this query using an explicit cast (#1)
>
>Well I don't know how to fix it, Looked through mailinlists, newsgroups
>etc.., but I can't find a proper solution.
>
>
>I would appreciate If anyone has an solution for this problem, or a
>suggestion ...
---=---
How do I use the row versioning -OR- why do I get a message about no
operator for xid and int4?
(from the ODBC faq):
Some of the operators are missing in the current release of Postgres so
in order to use row versioning, you must overload the int4eq function
for use with the xid type. Also, you need to create an operator to
compare xid to int4. You must do this for each database you want to use
this feature on. This will probably not be necessary in Postgres 6.4
since it will be added. Here are the details:
[WJB: As of 7.0, it has not been added, so you still have to do this.]
create function int4eq(xid,int4)
returns bool
as ''
language 'internal';
create operator = (
leftarg=xid,
rightarg=int4,
procedure=int4eq,
commutator='=',
negator='<>',
restrict=eqsel,
join=eqjoinsel
);
---=---
HTH,
--
Jamie Walker "While there are no known bugs in it, it might
jamie@sagaxis.co.uk destroy your filesystems, eat your data and
http://www.sagaxis.co.uk/ start World War III. You have been warned."
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: jamie@sagaxis.co.uk
Subject: Re: PostgreSQL -> ODBC -> MS ACCESS
In-Reply-To: <7ff7eVANVOM6Ew2y@sagaxis.co.uk>
* 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