On 03/30/2017 07:35 AM, harpagornis wrote:
In PgAdmin, when I right-click the table, in the Properties pane on the right
side of the screen, the tablespace is listed as "pg_default"
What we know. Correct me if I am wrong:
1) In postgresql.conf you have:
default_tablespace = ''
2) You created a table in the database:
CREATE TABLE myschema.mytable (rc_id integer NOT NULL) TABLESPACE
my_space;
FYI, the TABLESPACE is redundant as the table would created in my_space
anyway as it is the default for the database
3) When you queried pg_tables, the tablespace field is NULL for the
table. Which would be correct:
https://www.postgresql.org/docs/9.6/static/catalogs.html
tablespace name pg_tablespace.spcname Name of tablespace containing
table (null if default for database)
4) pgAdmin shows the tablespace as being pg_default for the table.
What we do not know:
1) Postgres version
2) pgAdmin version
3) select spcname from pg_database join pg_tablespace on
pg_database.dattablespace=pg_tablespace.oid where datname= your_db_name;
--
View this message in context: http://www.postgresql-archive.org/Tablespace-Default-Behavior-tp5952910p5953028.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
