[Qgis-user] postgis table not loading (2 column PK).
kwythers at umn.edu
Wed Jan 17 13:51:54 EST 2007
I've got a quick question for the list. I am trying (once again) to
add a postgis layer to qgis as map of "points". I have created a view
that contains data from three different tables. The view contains a
geometry column and two additional columns from a table that together
make up a primary key (and are therefor unique).
However, qgis will not add the view as a postgis layer. Qgis gives
the error message: The view 'public.climate_daily' has no column
suitable for use as a unique key.
Is Qgis trying to tell me that the veiw MUST contain a single column
that severs a primary key, and that the two column primary key will
not satisfy this requirement?
The index form the table that contains the PK is:
"weather_pkey" PRIMARY KEY, btree (station_id, date)
While the view definition is:
SELECT weather.station_id, sites.thepoint_meter, sites.longname,
weather.date, weather."year", weather."month", weather."day",
weather.doy, weather.tmin, weather.tmax, solar.rad, weather.precip
FROM sites, weather, solar
WHERE sites.station_id = weather.station_id AND sites.station_id =
solar.station_id AND weather.date = solar.date;
More information about the Qgis-user