Re: Schema and tablespace

Guillaume Lelarge wrote:
> Hi,
>
> One feature I want to add to next pgAdmin release is the change of
> schema for any objects (just as we can change the tablespace or owner of
> an object). I have some ideas on how to do this but I'm wondering if
> there was something that make this impossible to do. (Well, I know,
> strange question, but I don't why we can change tablespace but not
> schema... apart from the treeview changes it applies).

Shouldn't be. The schema is just something at the logical level, so you
should be able to change it around at will.

> Another feature I want deals with tablespace. When I select a
> tablespace, I would like to see all objects that belong to this
> tablespace. The way to handle this would be to add children to the
> tablespace nodes in the treeview. The problem I see is that every new
> object will need at least two nodes on the treeview (one in the schema
> part and one in the tablespace part). Do you see other problems with this ?

It would be neat to have. But maybe that's one step unnecessary - it
might be enough to just have a listview that has a column saying what
type it is, and another one saying the name? And the size probably,
since that's most likely why you're looking there?

//Magnus