From: | "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | permission denied for tablespace pg_global? |
Date: | 2007-10-09 13:19:42 |
Message-ID: | 006a01c80a77$0d8dc540$c601a8c0@HP22720319231 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi.
I'm looking at the strange phenomenon....
--
C:\Program Files\PostgreSQL\8.3-beta1\bin>psql postgres postgres
Password for user postgres:
Welcome to psql 8.3beta1, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
postgres=# select *,oid from pg_catalog.pg_tablespace;
spcname | spcowner | spclocation | spcacl | oid
------------+----------+-------------+--------+------
pg_default | 10 | | | 1663
pg_global | 10 | | | 1664
(2 rows)
postgres=# SELECT pg_size_pretty(pg_tablespace_size(1663));
pg_size_pretty
----------------
13 MB
(1 row)
postgres=# SELECT pg_size_pretty(pg_tablespace_size(1664));
ERROR: permission denied for tablespace pg_global
postgres=#
/END
Have I overlooked the present specification change?
or can someone suggest?
Regards,
Hiroshi Saito
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2007-10-09 13:33:45 | Re: the best format of FAQ for you |
Previous Message | Pavel Stehule | 2007-10-09 13:05:13 | Re: mal advice in FAQ 4.1. |