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

From Dave Page
Subject Re: pgadmin database restore display objects issue
Date
Msg-id CA+OCxowYc6zqh+pVDDbHhUxsG0wWR4dBuHSn-dE4q=BCOEztYg@mail.gmail.com
Whole thread Raw
In response to pgadmin database restore display objects issue  (Dharmendra Goyal <dharmendra.goyal@enterprisedb.com>)
List pgadmin-hackers
Thanks, patch applied.

On Tue, Mar 13, 2012 at 9:34 AM, Dharmendra Goyal
<dharmendra.goyal@enterprisedb.com> wrote:
> 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.
>
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: pgAdmin III commit: Fix handling of DEFAULT ACLs in the restore dialog
Next
From: Akshay Joshi
Date:
Subject: Fix some wxWidget 2.9 asserts