Tablespaces for indexes, tables and databases - Mailing list pgadmin-hackers

Hi developers! Hi Dave!


Testing the pgAdmin III 1.8.0  Beta 4 (Sep 4 2007, rev: 6608:6609).
Client Win XP, host: Debian Etch / PG 8.2.4 and Debian Sarge / PG 8.1.8

Moving indexes to different tablespaces via properties dialog seems to
work fine now. Good job!

The reverse engineered SQL for tables, indexes and databases includes an
extra line 'TABLESPACE pg_default' now, which seems redundant while it
matches the default (tablespace of the database / default_tablespace /
pg_default -- whichever comes first). We could get rid of the line for
these cases, i.e. in most cases.

There used to be an "empty" option in the combo box "Tablespace" (it
just did not work yet), which could do just that, explicitely.


== quote==
-- Index: test_myidx

-- DROP INDEX test_myidx;

CREATE INDEX test_myidx
  ON test
  USING btree
  (my_field)
  TABLESPACE pg_default;
== unquote==


Regards
Erwin