Re: duplicate primary key entries?
От | |
---|---|
Тема | Re: duplicate primary key entries? |
Дата | |
Msg-id | 43835.12.111.55.140.1069769789.squirrel@$HOSTNAME обсуждение исходный текст |
Ответ на | Re: duplicate primary key entries? (Baldur Norddahl <bbn-pgsql.general@clansoft.dk>) |
Список | 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@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; >>
В списке pgsql-general по дате отправления: