Thread: row versioning.

row versioning.

From
Dariusz Pietrzak
Date:
Hello,
 I am having strange problems - users are unable to edit data once they
entered it, they receive error saying that another user is editing their
data ( even if there are no other users ).
It seems like 'row versioning' would help, but with that I am having other
errors - this time from postgresql saying that it can't compare 'xid' with
'int4'.
 What can I do?

--
Dariusz Pietrzak
Certified Nobody


Re: row versioning.

From
Dariusz Pietrzak
Date:
> errors - this time from postgresql saying that it can't compare 'xid' with
> 'int4'.

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 just found that, seems like ODBC faq i printed was a little bit outdated
or sth.

--
Dariusz Pietrzak
Certified Nobody