RE: How to combine multiple field primary key and Row Versioning

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>