From: | Erwin Brandstetter <brandstetter(at)falter(dot)at> |
---|---|
To: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | Tablespaces for indexes, tables and databases |
Date: | 2007-09-05 13:22:53 |
Message-ID: | 46DEADAD.2090709@falter.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Erwin Brandstetter | 2007-09-05 13:57:51 | Crash when trying to view SQL for new unique constraint |
Previous Message | Jyrki Wahlstedt | 2007-09-05 12:12:05 | Re: two minor things |