Hello,
I suspect that it doesn't have the xid=int4 operator. Try adding the
following:
create function int4eq(xid,int4)
returns bool
as ''
language 'internal';
create operator = (
leftarg=xid,
rightarg=int4,
procedure=int4eq,
commutator='=',
negator='<>',
restrict=eqsel,
join=eqjoinsel
);
I'm assuming the server reported an error something like:
ERROR: Unable to identify an operator '=' for types 'xid' and 'int4'
You will have to retype this query using an explicit cast
Hope this helps,
- Stuart
> -----Original Message-----
> From: DI Hasenöhrl [SMTP:i.hasenoehrl@aon.at]
> Sent: Tuesday, June 26, 2001 11:37 AM
> To: pgsql-odbc@postgresql.org
> Subject: How to combine multiple field primary key and Row Versioning
>
> Hello,
>
> I use Postgrsql 7.0.2 and ODBC 7.1.003. I discovered, that Row Versioning
> doesn't work with multiple field primary keys.
> I need Row Versioning to be able to change tuples of a table, inserted by
> a function and I use multiple field primary keys to be sure, that inserted
> data are correct ie table *sortiment* contains the articles of each year
>
> create table sortiment(
> year integer,
> article_nr integer,
> number integer,
> primary key(year,article_nr)
> );
>
>
> Are there further releases, which can combine multiple field primary keys
> and Row Versioning, or does anyone have any ideas, how to solve this
> confict?
>
> Thanks in advance for any hint
> Irina
>
> E-Mail: i.hasenoehrl@aon.at <mailto:i.hasenoehrl@aon.at>