pgadmin 8.3 beta 5: ERROR: permission denied for tablespace pg_default
От | Harald Armin Massa |
---|---|
Тема | pgadmin 8.3 beta 5: ERROR: permission denied for tablespace pg_default |
Дата | |
Msg-id | 7be3f35d0709130100r4d4138dbmf3ed859a53535af7@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: pgadmin 8.3 beta 5: ERROR: permission denied for tablespace pg_default
Re: pgadmin 8.3 beta 5: ERROR: permission denied for tablespace pg_default Re: pgadmin 8.3 beta 5: ERROR: permission denied for tablespace pg_default |
Список | pgadmin-support |
Hello,<br /><br />it may or may not be considered as a pgadmin error:<br /><br />I try to create an index on a column ofa table. Using the pgadmin-wizard, that results in:<br /><br />CREATE INDEX otformularkopf_test<br /> ON otformularkopf(id_pkfk) <br /> TABLESPACE pg_default;<br /><br />with NO chance to get rid of the " TABLESPACEpg_default" clause; so I am stuck with "ERROR: permission denied for tablespace pg_default"<br /><br />Accordingto the words of Master Tom in <a href="http://svr5.postgresql.org/pgsql-hackers/2004-06/msg00947.php">http://svr5.postgresql.org/pgsql-hackers/2004-06/msg00947.php</a>,<br />"Joe User probably <font><font face="Arial, Helvetica, sans-serif">shouldn't be fooling with tablespaces at all." <br /><br/>the "Joe User way" to create an index would be:<br /></font></font><br />CREATE INDEX otformularkopf_test<br /> ON otformularkopf (id_pkfk);<br /><br />and allow Postgres to decide in which tablespace to put that index. But the "tablespace"dropdown is not blankable.<br /><br />So my suggestion: make tablespace default blank in the wizards. <br /><br/>Harald<br clear="all" /><br />-- <br />GHUM Harald Massa<br />persuadere et programmare<br />Harald Armin Massa<br/>Spielberger Straße 49<br />70435 Stuttgart<br />0173/9409607<br />fx 01212-5-13695179 <br />-<br />EuroPython 2008will take place in Vilnius, Lithuania - Stay tuned!
В списке pgadmin-support по дате отправления: