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@svana.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@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
>




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