Re: Getting more than one row in UNIQUE fields

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Getting more than one row in UNIQUE fields
Date: 2009-12-06 08:55:43
Message-ID: hffrif$u2k$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2009-12-04, Another Trad <anothertrad(at)gmail(dot)com> wrote:
> --001485f94df095921c0479ea62fd
> Content-Type: text/plain; charset=ISO-8859-1
>
> My table 'client' has the unique 'client_id'.
> My test server, when I try:
> select * from client where client_id = 12
> My server returns 3 rows!!!!

I had similar with a client on friday, windows event log shouwed disk
errors, chkdsk showed damaged database files.

I passed the problem back to their IT guy.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Postgre Novice 2009-12-07 13:00:58 Query Performance
Previous Message Alvaro Herrera 2009-12-04 19:24:34 Re: get sequence name from table name