Re: pgadmin 8.3 beta 5: ERROR: permission denied for tablespace pg_default

This is definitely a change from PgAdmin 1.6. 1.6 had the blank pull down.
In fact 1.6 offered three options: blank, pg_default, pg_global. 1.8 only
offers one: pg_default

On 9/13/07, Harald Armin Massa <haraldarminmassa(at)gmail(dot)com> wrote:
>
> Hello,
>
> it may or may not be considered as a pgadmin error:
>
> I try to create an index on a column of a table. Using the pgadmin-wizard,
> that results in:
>
> CREATE INDEX otformularkopf_test
> ON otformularkopf (id_pkfk)
> TABLESPACE pg_default;
>
> with NO chance to get rid of the " TABLESPACE pg_default" clause; so
> I am stuck with "ERROR: permission denied for tablespace pg_default"
>
> According to the words of Master Tom in
> http://svr5.postgresql.org/pgsql-hackers/2004-06/msg00947.php,
> " Joe User probably shouldn't be fooling with tablespaces at all."
>
> the "Joe User way" to create an index would be:
>
> CREATE INDEX otformularkopf_test
> ON otformularkopf (id_pkfk);
>
> and allow Postgres to decide in which tablespace to put that index. But
> the "tablespace" dropdown is not blankable.
>
> So my suggestion: make tablespace default blank in the wizards.
>
> Harald
>
> --
> GHUM Harald Massa
> persuadere et programmare
> Harald Armin Massa
> Spielberger Straße 49
> 70435 Stuttgart
> 0173/9409607
> fx 01212-5-13695179
> -
> EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!