pgadmin database restore display objects issue

From: Dharmendra Goyal <dharmendra(dot)goyal(at)enterprisedb(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: pgadmin database restore display objects issue
Date: 2012-03-13 09:34:52
Message-ID: CAOh5NjwvAiDWgOm9s3LK0qE04FuWV9WjN0bPG2z8orBUXspnxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi,

There was an issue with "display objects" event on restore database
dialogue.

We can take backup of any database successfully but when try to restore the
backup by clicking on "display objects", it displays error message: "schema
node not found".
Steps:
1. click on any database and take a backup with tar or custom option.
2. create new database suppose 'a'
3. Click on restore database
4. Click on "display objects". It will display error message: "schema not
found"
Analysis:
Following type of statements were not handled properly. In this case second
token is being considered as schema name which causes the error.
DEFAULT ACL <schema name> DEFAULT PRIVILEGES FOR TABLES <privilege>

Please find attached the patch which fixes this issue.

Thanks,

--
Dharmendra Goyal
Senior Software Engineer
EnterpriseDB Corporation
The Enterprise Postgres Company

Phone: +91-20-30589493
Mobile: +91-9552103323

Website: http://www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com/
Follow us on Twitter: http://www.twitter.com/enterprisedb

This e-mail message (and any attachment) is intended for the use of the
individual or entity to whom it is addressed. This message contains
information from EnterpriseDB Corporation that may be privileged,
confidential, or exempt from disclosure under applicable law. If you are
not the intended recipient or authorized to receive this for the intended
recipient, any use, dissemination, distribution, retention, archiving, or
copying of this communication is strictly prohibited. If you have received
this e-mail in error, please notify the sender immediately by reply e-mail
and delete this message.

Attachment Content-Type Size
pgadmin_default_acl_handling.patch application/octet-stream 867 bytes

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Timon 2012-03-13 11:13:27 Re: pgAdmin III commit: Fix another issue related to wxWidgets 2.9
Previous Message Guillaume Lelarge 2012-03-12 21:44:29 pgAdmin III commit: Get rid of the weird cursors in the DD