From: | <btober(at)seaworthysys(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: duplicate primary key entries? |
Date: | 2003-11-25 14:16:29 |
Message-ID: | 43835.12.111.55.140.1069769789.squirrel@$HOSTNAME |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(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;
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Farrell | 2003-11-25 14:24:25 | Re: Can't initdb, libdir points to static location |
Previous Message | Baldur Norddahl | 2003-11-25 14:05:16 | Re: duplicate primary key entries? |