Re: duplicate primary key entries? - Mailing list pgsql-general

On Tue, Nov 25, 2003 at 12:22:29PM +0100, Baldur Norddahl wrote:
> Hi,
>
> I just noticed something bad in our database:
>
> webshop=# select oid,* from content_loc where id=20488;
>    oid   |  id   | locale |     name
> ---------+-------+--------+--------------
>  9781056 | 20488 | any    | Rise Part II
>  9781058 | 20488 | any    | Rise Part II
> (2 rows)

Any possibility there are hidden spaces? What is the output of:

select oid,id,'['||locale||']','['||name||']' from content_loc where id=20488;

Hope this helps,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato