Row versioning in the ODBC driver...

From: Tom Samplonius <tom(at)sdf(dot)com>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Row versioning in the ODBC driver...
Date: 2000-09-11 02:27:01
Message-ID: Pine.BSF.4.05.10009101922180.19223-100000@misery.sdf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces


Row versioning in the ODBC driver apparently does not work because of a
missing operator. The FAQ solution is contained below. The answer
suggests that this problem should be fixed in PostgreSQL 6.4, but I'm
using 7.0.2 and I still get the missing operator error if I attempt to
enable row versioning.

Is it possible to get this operator included in the next release?

How do I use the row versioning -OR- why do I get a message about no
operator for xid and int4?

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:
create function int4eq(xid,int4)
returns bool
as ''
language 'internal';

create operator = (
leftarg=xid,
rightarg=int4,
procedure=int4eq,
commutator='=',
negator='<>',
restrict=eqsel,
join=eqjoinsel
);

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2000-09-11 07:40:31 need asap: bg_BG locale for FreeBSD
Previous Message The Hermit Hacker 2000-09-10 22:38:52 man, I feel like a beginner ...

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Mount 2000-09-11 06:53:52 RE: JDBC and Unicode problem
Previous Message Morgan Greenwood 2000-09-11 01:07:16 jdbc - prepared statement and cvs questions