Oops, sorry forgot a little bit of script for the backend:
create function int4eq(xid,int4)
returns bool
as ''
language 'internal';
create operator = (
leftarg=xid,
rightarg=int4,
procedure=int4eq,
commutator='=',
negator='<>',
restrict=eqsel,
join=eqjoinsel
);
This should give a suitable a suitable operator. I think theres an MS Access
FAQ on odbc.postgresql.org and on techdocs.postgresql.org which may also
help you
- Stuart
> -----Original Message-----
> From: Maryann F Stopha [SMTP:stopha@geneseo.edu]
> Sent: Friday, July 20, 2001 3:16 PM
> To: Pgsql-Odbc@postgresql.org
> Subject: Re: Access 2000 and ODBC driver Data changed by another
> user, Cop y to Clipboard or Drop changes
>
> Hi Stuart, thank you for your reply.
>
> I turned on row versioning, relinked the tables, and I'm now getting ODBC
> --update on a linked table 'organizations' failed.
>
> Error while exectuing the query;
> ERROR: Unable to identify an operator '=' for types 'xid' and 'int4'
> You will have to retype this query using an explicit cast (#7)
>
> Anyone have any ideas on this one?
>
> Maryann
>
>
> On 7/20/01 5:32 AM, "Henshall, Stuart - WCP"
> <SHenshall@westcountrypublications.co.uk> wrote:
>
> > Are you using row versioning? If not give it a go (you'll need to relink
> > tables after enabling)
> > - Stuart
> >
> >> -----Original Message-----
> >> From: Maryann F Stopha [SMTP:stopha@geneseo.edu]
> >> Sent: Thursday, July 19, 2001 4:22 PM
> >> To: Pgsql-Odbc@postgresql.org
> >> Subject: Access 2000 and ODBC driver Data changed by another user,
> >> Copy to Clipboard or Drop changes
> >>
> >> Hi,
> >>
> >> I'm working on a machine that was upgraded to office 2000.
> >>
> >> I updated the odbc driver to the most recent, and I'm getting the -Data
> >> changed by another user, Copy to Clipboard or Drop changes message
> (data
> >> is
> >> being accessed by another)- error. We can't modify or add any data in
> the
> >> database from Access because of this error.
> >>
> >> This does not happen in Access 97. Does anyone have any ideas as to
> why
> >> Access 2000 will gives error? There's no numeric data in the database,
> >> it's
> >> all text.
> >>
> >> Thanks,
> >> Maryann Stopha
> >> --
> >> Web Development Professional
> >> Computing & Information Technology
> >> SUNY Geneseo
> >> 716.245.5577
> >> stopha@geneseo.edu
> >>
> >>
>