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 <[EMAIL PROTECTED]> 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!
