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!