You could have one additional column that contains a hash of the entire row, so you'd only need a unique index on this
hashcolumn.
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@postgresql.org)
>