Re: Getting more than one row in UNIQUE fields - Mailing list pgsql-sql

From Jasen Betts
Subject Re: Getting more than one row in UNIQUE fields
Date
Msg-id hffrif$u2k$1@reversiblemaps.ath.cx
Whole thread Raw
In response to Getting more than one row in UNIQUE fields  (Another Trad <anothertrad@gmail.com>)
List pgsql-sql
On 2009-12-04, Another Trad <anothertrad@gmail.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.


pgsql-sql by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: get sequence name from table name
Next
From: Postgre Novice
Date:
Subject: Query Performance