Subject | Re: Concurrency problem when using named cursors |
---|---|
Author | hvlad |
Post date | 2011-05-23T08:17:47Z |
--- In firebird-support@yahoogroups.com, "roger" wrote:
Regards,
Vlad
>Enter it into tracker, please.
> If, in PSQL, I open a named cursor on a record, and some other operation changes a field in that record, then the change is lost when I post using the cursor, even if the cursor does not fetch the changed field.
>
> If I define the cursor as FOR UPDATE OF MY_FIELD WITH LOCK, then the system crashes if, after some other operation changes the record, I try to post using the cursor.
>
> How do I maintain concurrency when using named cursors? Am I doing something wrong?
Regards,
Vlad