Re: Unique rows without a key

You could have one additional column that contains a hash of the entire row, so you'd only need a unique index on this hash column.

cheers,
thalis

On Wed, 13 Jun 2001, Steve Micallef wrote:

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>