Re: duplicate primary key entries?

Dumb question, but is id actually defined as the primary key constraint
in the table definition?

~Berend Tober


> 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;
>>