From: | "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk> |
---|---|
To: | 'DI Hasenöhrl' <i(dot)hasenoehrl(at)aon(dot)at>, pgsql-odbc(at)postgresql(dot)org |
Subject: | RE: How to combine multiple field primary key and Row Versioning |
Date: | 2001-06-28 08:24:55 |
Message-ID: | E2870D8CE1CCD311BAF50008C71EDE8E01F745FE@MAIL_EXCHANGE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(dot)hasenoehrl(at)aon(dot)at]
> Sent: Tuesday, June 26, 2001 11:37 AM
> To: pgsql-odbc(at)postgresql(dot)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(dot)hasenoehrl(at)aon(dot)at <mailto:i(dot)hasenoehrl(at)aon(dot)at>
From | Date | Subject | |
---|---|---|---|
Next Message | DI Hasenöhrl | 2001-06-28 10:39:16 | Re: How to combine multiple field primary key and Row Versioning |
Previous Message | Dave Page | 2001-06-27 10:25:04 | psqlODBC v07.01.0006 available for download. |