pgadmin database restore display objects issue - Mailing list pgadmin-hackers

From Dharmendra Goyal
Subject pgadmin database restore display objects issue
Date
Msg-id CAOh5NjwvAiDWgOm9s3LK0qE04FuWV9WjN0bPG2z8orBUXspnxw@mail.gmail.com
Whole thread Raw
Responses Re: pgadmin database restore display objects issue  (Dave Page <dpage@pgadmin.org>)
List 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

pgadmin-hackers by date:

Previous
From: Guillaume Lelarge
Date:
Subject: pgAdmin III commit: Get rid of the weird cursors in the DD
Next
From: Timon
Date:
Subject: Re: pgAdmin III commit: Fix another issue related to wxWidgets 2.9