Tablespaces for indexes, tables and databases

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

Responses

Browse pgadmin-hackers by date

  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