On 07/07/11 1:02 PM, Rich Shepard wrote:
On Thu, 7 Jul 2011, Alan Hodgson wrote:
create unique index index_name on table (column).
Alan,
This worked like a charm.
Many thanks for the lesson,
Rich
if your original table has Primary Key of (sta_type, secondary_type) I
would not expect EITHER of those fields to be unique by themselves....
Surely there can be more than one of the same sta_type with different
secondary_type's, just as there could be more than one secondary_type
with different sta_types.... if either of these fields is unique of
and by itself, it doesn't make sense to use the combined primary key.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
