Bug report #12680

DBManager don't recognize a PostGIS geography table (or view) as geometrical

Added by Marco Li Volsi over 4 years ago. Updated 11 months ago.

Status:Closed
Priority:Normal
Assignee:-
Category:DB Manager
Affected QGIS version:2.8.1 Regression?:No
Operating System:Windows Easy fix?:No
Pull Request or Patch supplied:No Resolution:end of life
Crashes QGIS or corrupts data:No Copied to github as #:20787

Description

DBManager don't recognize a PostGIS geography table (or view) as geometrical, but only alphanumerical

History

#1 Updated by Anita Graser over 4 years ago

Did you add an entry into geometry_columns with metadata for the view?

Please add more detail to the description.

#2 Updated by Marco Li Volsi over 4 years ago

Hy Anita.
I have PostGIS "2.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1" version on "PostgreSQL 9.4.0, compiled by Visual C++ build 1800, 64-bit" version.
My table/view is in public.geography_columns view but not in public.geometry_columns view. The geometry_columns table is not in my database (I remenber that before PostGIS 2.0.0 version was a table).

#3 Updated by Giovanni Manghi over 4 years ago

  • Status changed from Open to Feedback

this tables do show using the "add postgis layer" dialog or the qgis browser?

#4 Updated by Marco Li Volsi over 4 years ago

Yes Giovanni,
these tables/views are correctly recognized as geometrical by "add postgis layer" or QGis Browser.

#5 Updated by Giovanni Manghi over 4 years ago

  • Status changed from Feedback to Open

#6 Updated by Giovanni Manghi over 2 years ago

  • Regression? set to No
  • Easy fix? set to No

#7 Updated by Giovanni Manghi 11 months ago

  • Resolution set to end of life
  • Status changed from Open to Closed

Also available in: Atom PDF