Re: Problem with restore

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.


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