Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Browser: dropping a view fails #29812

Closed
qgib opened this issue May 5, 2019 · 0 comments
Closed

Browser: dropping a view fails #29812

qgib opened this issue May 5, 2019 · 0 comments
Assignees
@wonder-sk
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter!

Comments

@qgib
Copy link
Contributor

qgib commented May 5, 2019

Author Name: Paolo Cavallini (@pcav)
Original Redmine Issue: 21997
Affected QGIS version: 3.4.7
Redmine category:browser

Dropping a view from the Browser fails:

Impossibile eliminare layer "public"."pippo":
ERROR: "pippo" is not a table
NOTA: Use DROP VIEW to remove a view.
CONTESTO: SQL statement "DROP TABLE IF EXISTS public.pippo RESTRICT"
PL/pgSQL function dropgeometrytable(character varying,character varying,character varying) line 15 at EXECUTE
@qgib qgib added the Bug Either a bug report, or a bug fix. Let's hope for the latter! label May 25, 2019
@wonder-sk wonder-sk self-assigned this May 30, 2019
wonder-sk added a commit to wonder-sk/QGIS that referenced this issue May 30, 2019
@wonder-sk
[browser] Fix removal of views from postgres databases (fixes qgis#29812
c859bc2 
)

For views one needs to use DROP VIEW sql command
backporting bot pushed a commit that referenced this issue May 31, 2019
@wonder-sk
[browser] Fix removal of views from postgres databases (fixes #29812)
8441785 
For views one needs to use DROP VIEW sql command
nyalldawson pushed a commit that referenced this issue Jun 3, 2019
@wonder-sk @nyalldawson
[browser] Fix removal of views from postgres databases (fixes #29812)
7229a7d 
For views one needs to use DROP VIEW sql command
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@wonder-sk wonder-sk

Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter!
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@wonder-sk @qgib