Обсуждение: Bug -PGAdmin 1.12.2

O/S - Windows XP Service Pack 3
Language - English
Distribution - binary (.zip)
Version you tested 1.12.2

Bug:
Attempting to backup a CamelCase named database (eg: MyDataBase) fails with
C:\Program Files\pgAdmin III\1.12\pg_dump.exe --host 172.26.15.104 --port 5432 --username "mdavidson" --format custom --blobs --verbose
--file "C:\PostgreSQL\backups\x.backup" \"ICSPayments\"
pg_dump: [archiver (db)] connection to database ""MyDataBase"" failed: FATAL:  database ""MyDataBase"" does not exist
pg_dump: *** aborted because of error

Process returned exit code 1.

Backing up a database that is all lowercase succeeds.

Le 10/02/2011 22:12, Melvin Davidson a écrit :
> O/S - Windows XP Service Pack 3
> Language - English
> Distribution - binary (.zip)
> Version you tested 1.12.2
> 
> Bug:
> Attempting to backup a CamelCase named database (eg: MyDataBase) fails with
> C:\Program Files\pgAdmin III\1.12\pg_dump.exe --host 172.26.15.104 --port 5432 
> --username "mdavidson" --format custom --blobs --verbose
> --file "C:\PostgreSQL\backups\x.backup" \"ICSPayments\"
> pg_dump: [archiver (db)] connection to database ""MyDataBase"" failed: *FATAL: 
> database ""**MyDataBase**"" does not exist*
> pg_dump: *** aborted because of error
> 
> Process returned exit code 1.
> 
> *Backing up a database that is all lowercase succeeds.*
> 

This is already fixed. It'll be available in the next minor release.

Thanks for your report.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com

Le 10/02/2011 22:37, Melvin Davidson a écrit :
> Guillaume,
> 
> Thank you very much for your reply and contributions to PgAdmin!
> 

You're welcome.

> FYI, In further testing of the backup, selective object backup is ignored, 
> (options tab of backup) and all objects are backed up regardless.
> 

Works for me here. What are your exact steps?


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com

>Works for me here. What are your exact steps?

Steps to duplicate:

1. Right Click on a database
2. Click on Backup
3. In popup screen, specify filename.
4. Click the Objects Tab
5. Uncheck the database (1st box)
6. Specifically check two or more individual tables, but not all.
7. Click OK

Poof! All tables are copied, regardles of whether they are checked or not.

FYI, In further testing of the backup, selective object backup is ignored, 
(options tab of backup) and all objects are backed up regardless.

Works for me here. What are your exact steps?

Le 22/02/2011 23:37, Melvin Davidson a écrit :
>> Works for me here. What are your exact steps?
>>
>> Steps to duplicate:
>>
>> 1. Right Click on a database
>> 2. Click on Backup
>> 3. In popup screen, specify filename.
>> 4. Click the Objects Tab
>> 5. Uncheck the database (1st box)
>> 6. Specifically check two or more individual tables, but not all.
>> 7. Click OK
>>

OK. As soon as you unchecked the database checkbox or a schema checkbox,
nothing below the checkbox is checked. Not sure what the correct fix
should be. I was thinking that once you click on a table, pgAdmin should
check that the schema is checked and that the database is checked too.
And check them if they aren't. What do you think?


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com

Le 23/02/2011 23:49, Melvin Davidson a écrit :
> Guillaume,
> 
> True, nothing below the database or schema checkbox was checked,
> but to me, that should not matter. The command line should be altered to use the 
> individual -t flag
> for the tables that are then checked.
> 
> Perhaps a final check of "No Objects Selected" should disable the OK button?
> 

I fixed this another way. Once you click on a table, the schema and the
database are automatically checked, so that you don't have to care about it.

Thanks for your report.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com