Re: pgadmin database restore display objects issue

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Dharmendra Goyal <dharmendra(dot)goyal(at)enterprisedb(dot)com>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: pgadmin database restore display objects issue
Date: 2012-03-13 12:40:36
Message-ID: CA+OCxowYc6zqh+pVDDbHhUxsG0wWR4dBuHSn-dE4q=BCOEztYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Thanks, patch applied.

On Tue, Mar 13, 2012 at 9:34 AM, Dharmendra Goyal
<dharmendra(dot)goyal(at)enterprisedb(dot)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(at)postgresql(dot)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

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Akshay Joshi 2012-03-13 13:41:10 Fix some wxWidget 2.9 asserts
Previous Message Dave Page 2012-03-13 12:39:37 pgAdmin III commit: Fix handling of DEFAULT ACLs in the restore dialog