Unique rows without a key

From: Steve Micallef <stevenm(at)ot(dot)com(dot)au>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Unique rows without a key
Date: 2001-06-12 23:00:33
Message-ID: 20010613085740.O37166-100000@toaster.syd.ot
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is there any way to force every row in a table to be unique without
creating a unique key?

My tables are fairly large (growing by a gig a day) and creating a primary
key would basically double my disk usage.

Thanks for your help,

Steve Micallef

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-12 23:16:26 Re: Connection Timeout ?
Previous Message Peter Eisentraut 2001-06-12 22:11:42 Re: abs() does not exists..