REYNAUD Jean-Samuel <[EMAIL PROTECTED]> writes:
> When I use a "select for update" request whitch uses an index, the
> locking system is inconsistant.
I've applied the attached patch to HEAD and 8.1 to fix this.
regards, tom lane
Index: createplan.c
REYNAUD Jean-Samuel <[EMAIL PROTECTED]> writes:
> test=# explain select s.id_session from users u, sessions s where
> to_date IS NULL and u.id_user = s.id_user;
>QUERY PLAN
>
Hi all,
I had a lock problem on my database.
When I use a "select for update" request whitch uses an index, the
locking system is inconsistant.
Take this example:
test=# \d users
Table "public.users"
Column | Type |Modifiers
-+