Advertisement
Guest User

Untitled

a guest
Dec 6th, 2011
191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.46 KB | None | 0 0
  1. The view 'public.export2' has no column suitable for use as a unique key.
  2. Quantum GIS requires that the view has a column that can be used as a unique key. Such a column should be derived from a table column of type int4 and be a primary key, have a unique constraint on it, or be a PostgreSQL oid column. To improve performance the column should also be indexed.
  3. The view you selected has the following columns, none of which satisfy the above conditions:
  4. 'date_inserted' derives from 'public.wikimapia.datestamp' and is not suitable (type is date) and does not have a suitable constraint)
  5. 'date_taken' derives from 'public.panoramio.upload_date' and is not suitable (type is date) and does not have a suitable constraint)
  6. 'description' derives from 'public.flickr.description' and is not suitable (type is text) and does not have a suitable constraint)
  7. 'geom' derives from 'public.flickr.point_geom' and is not suitable (type is geometry) and does not have a suitable constraint)
  8. 'id' derives from 'public.flickr.point_geom' and is not suitable (type is geometry) and does not have a suitable constraint)
  9. 'service' derives from 'public.flickr.point_geom' and is not suitable (type is geometry) and does not have a suitable constraint)
  10. 'title' derives from 'public.panoramio.photo_title' and is not suitable (type is text) and does not have a suitable constraint)
  11. 'url' derives from 'public.flickr.photo_url' and is not suitable (type is text) and does not have a suitable constraint)
  12.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement