Обсуждение: pgadmin database restore display objects issue
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"
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.
Вложения
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