Re: Problem with restore

Le 20/04/2010 18:52, Guillaume Lelarge a écrit :
> Hi,
> 
> Le 20/04/2010 18:18, Kieran McCusker a écrit :
>> [...]
>> Sorry if this has been raised before but I have just tried to restore a
>> table from one of my schemas.
>>
>> The problem was that this table name is very common - It is used in many
>> schemas as each schema is the data for an individual client.
>>
>> Restore has the three disabled checkboxes
>> Only data    (checked)
>> Only schema    (unchecked)
>> Single object    (checked)
>>
>> and then below
>> Table (my table name)
>>
>> I assumed was it was going to restore only the selected table - What it
>> actually did was restore all tables with that name!
>>
> 
> Yes, the Restore window launches pg_restore with the --table option, but
> doesn't specify the schema name.
> 
>> This seems confusing at best (and how would you do what I wanted using
>> the UI?)
>>
> 
> There's no way to do this with the UI. But this is a bug and should be
> fixed.
> 
>> Shouldn't the schema be checked as well?
>>
> 
> Yes.
> 
> The good behaviour is already available in the backup window. I just
> need to push it also in the restore window. Will do this evening.
> 

Fixed for the next 1.10 and the future 1.12 releases.

Thanks for your report.


-- 
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com