On Thu, 7 Jul 2011, Alan Hodgson wrote:

You need a unique index on station_type.sta_type

Alan,

  station_type(sta_type) is part of a composite primary key. Doesn't primary
key automatically imply unique and not null?

Thanks,

Rich

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to