BUG #1681: Selection problem - Mailing list pgsql-bugs

From fremaux
Subject BUG #1681: Selection problem
Date
Msg-id 20050526135044.5B6FFF0B0C@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1681: Selection problem  (Michael Fuhr <mike@fuhr.org>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      1681
Logged by:          fremaux
Email address:      benjamin.fremaux@sofrecom.com
PostgreSQL version: 7.2.2
Operating system:   Linux kernel 2.4.6.19-mdk
Description:        Selection problem
Details:

following query :
SELECT list.group_artifact_id, list.name
FROM artifact_group_list list
WHERE (list.group_artifact_id=167)

returns 2 lines where the first list.group_artifact_id equals "165". The
problem is that the only lines that have to be returned are the ones with
list.group_artifact_id=167

pgsql-bugs by date:

Previous
From: shd@t2.technion.ac.il
Date:
Subject: creating users
Next
From: "Qingqing Zhou"
Date:
Subject: Re: concurrent drop table with fkeys corrupt pg_trigger