Re: duplicate primary key entries?

Hi,

No, there can be no space after 'any' because the foreign key prevents it (which
you of course could not check since I didn't show the content of the foreign
table).

But anyway, here is the output:

webshop=# select oid,id,'['||locale||']','['||name||']' from content_loc where
id=20488 and locale='any';
oid | id | ?column? | ?column?
---------+-------+----------+----------------
9781056 | 20488 | [any] | [Rise Part II]
9781058 | 20488 | [any] | [Rise Part II]
(2 rows)

Baldur

Quoting Martijn van Oosterhout <kleptog(at)svana(dot)org>:

> 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(at)svana(dot)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
>

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.