Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: pgadmin_default_acl_handling.patch
Description: application/octet-stream (867 bytes)

Responses

pgadmin-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group