Re: [HACKERS] FOR UPDATE lock problem ?

2006-04-25 Thread Tom Lane
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

Re: [HACKERS] FOR UPDATE lock problem ?

2006-04-25 Thread Tom Lane
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 >

[HACKERS] FOR UPDATE lock problem ?

2006-04-25 Thread REYNAUD Jean-Samuel
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 -+