Postgres Pro
Downloads
Home   >   mailing lists

[pgAdmin3][Extension]: Wrong SQL generated - Mailing list pgadmin-hackers

From Surinder Kumar
Subject [pgAdmin3][Extension]: Wrong SQL generated
Date
Msg-id CAM5-9D8hPH9Hj8mAq+XorWvV7N4xKn5g3PCUj-x6UhhCReiPmQ@mail.gmail.com
Whole thread Raw
Responses Re: [pgAdmin3][Extension]: Wrong SQL generated  (Neel Patel <neel.patel@enterprisedb.com>)
List pgadmin-hackers
Tree view
Hi all,


While implementing Extension module in pgAdmin4, I came to know that there is an bug in pgadmin3.

Following are the steps to reproduce it:
1. Edit an existing extension.
2. In definition tab, set schema and version fields to empty.
3. In SQL tab, it generates an sql for the changes made which is wrong, it shouldn't generate sql for the schema and version field if it is kept empty, both fields should be validated.


Below is the wrong SQL generated:

ALTER EXTENSION btree_gin
  SET SCHEMA ;
ALTER EXTENSION btree_gin
  UPDATE TO ;


Let me know for any comments.

Thanks
Surinder Kumar

pgadmin-hackers by date:

Previous
From: Ashesh Vashi
Date:
Subject: pgAdmin 4 commit: Chagned the variable control to use the new format of
Next
From: Neel Patel
Date:
Subject: Re: [pgAdmin4] [Patch]: Extension Module