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@aklaver.com
