On 03/30/2017 10:02 AM, harpagornis wrote:
Nope, I installed v4.1.3 and it is the same, pg_default appears as the
tablespace. Even when I use the drop down list in the right pane of PgAdmin
to select the my_space tablespace, and then click the Save button, it does
not change.
pgAdmin is a sepa
Nope, I installed v4.1.3 and it is the same, pg_default appears as the
tablespace. Even when I use the drop down list in the right pane of PgAdmin
to select the my_space tablespace, and then click the Save button, it does
not change.
--
View this message in context:
http://www.postgresql-archi
On 03/30/2017 08:36 AM, harpagornis wrote:
Postgres version is 9.4
PgAdmin version is 1.0
Alright seems this is a known issue:
https://redmine.postgresql.org/issues/2069
You will need a Postgres coummunity account:
https://www.postgresql.org/account/signup/
to see the issue though.
Thoug
Postgres version is 9.4
PgAdmin version is 1.0
The value returned by the suggested query is correctly reported as
'my_space'.
--
View this message in context:
http://www.postgresql-archive.org/Tablespace-Default-Behavior-tp5952910p5953046.html
Sent from the PostgreSQL - general mailing list
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
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"
--
View this message in context:
http://www.postgresql-archive.org/Tablespace-Default-Behavior-tp5952910p5953028.html
Sent from the PostgreSQL - general ma
On 03/29/2017 09:18 PM, harpagornis wrote:
That is what I suspected, and thank you for the explanation. I think it is
misleading and a bug in PgAdmin for explicitly listing the tablespace as
pg_default.
Listing it where?
--
View this message in context:
http://www.postgresql-archive.org/
That is what I suspected, and thank you for the explanation. I think it is
misleading and a bug in PgAdmin for explicitly listing the tablespace as
pg_default.
--
View this message in context:
http://www.postgresql-archive.org/Tablespace-Default-Behavior-tp5952910p5952929.html
Sent from the Po
harpagornis writes:
> When I create a table, like this:
> CREATE TABLE myschema.mytable (rc_id integer NOT NULL) TABLESPACE
> my_space;
> and then I do:
> select * from pg_tables where schemaname ='myschema';
> the tablespace is blank for the new table. When I look in PgAdmin, the
> tabl
More Info Edit: Also, the database is in the my_space tablespace. The
location for the my_space tablespace is a different folder than the $PGDATA
folder.
--
View this message in context:
http://www.postgresql-archive.org/Tablespace-Default-Behavior-tp5952910p5952917.html
Sent from the Post
I am somewhat new to Postgresql. I cant seem to create a table in a
non-default tablespace. In the postgresql.conf file, I have:
default_tablespace = ''".
When I create a table, like this:
CREATE TABLE myschema.mytable (rc_id integer NOT NULL) TABLESPACE
my_space;
and then I do:
se
11 matches
Mail list logo
