Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commite472ebd

Browse files
committed
doc: clarify hierarchy of objects: global, db, schema, etc.
The previous wording was confusing because it wasn't in decreasing orderand had to backtrack. Also clarify role/user wording.Reported-by: jbird@nuna.comDiscussion:https://postgr.es/m/158057750885.1123.2806779262588618988@wrigleys.postgresql.orgBackpatch-through: 9.5
1 parente564c17 commite472ebd

File tree

2 files changed

+14
-17
lines changed

2 files changed

+14
-17
lines changed

‎doc/src/sgml/ddl.sgml‎

Lines changed: 7 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -2054,19 +2054,18 @@ SELECT * FROM information WHERE group_id = 2 FOR UPDATE;
20542054
</indexterm>
20552055

20562056
<para>
2057-
A <productname>PostgreSQL</productname> database cluster
2058-
contains one or more named databases. Users and groups of users are
2059-
shared across the entire cluster, but no other data is shared across
2060-
databases. Any given client connection to the server can access
2061-
only the data in a single database, the one specified in the connection
2062-
request.
2057+
A <productname>PostgreSQL</productname> database cluster contains
2058+
one or more named databases. Roles and a few other object types are
2059+
shared across the entire cluster. A client connection to the server
2060+
can only access data in a single database, the one specified in the
2061+
connection request.
20632062
</para>
20642063

20652064
<note>
20662065
<para>
20672066
Users of a cluster do not necessarily have the privilege to access every
2068-
database in the cluster. Sharing ofuser names means that there
2069-
cannot be differentusers named, say, <literal>joe</literal> in two databases
2067+
database in the cluster. Sharing ofrole names means that there
2068+
cannot be differentroles named, say, <literal>joe</literal> in two databases
20702069
in the same cluster; but the system can be configured to allow
20712070
<literal>joe</literal> access to only some of the databases.
20722071
</para>

‎doc/src/sgml/manage-ag.sgml‎

Lines changed: 7 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -22,15 +22,13 @@
2222
</indexterm>
2323

2424
<para>
25-
A database is a named collection of <acronym>SQL</acronym> objects
26-
(<quote>database objects</quote>). Generally, every database
27-
object (tables, functions, etc.) belongs to one and only one
28-
database. (However there are a few system catalogs, for example
29-
<literal>pg_database</literal>, that belong to a whole cluster and
30-
are accessible from each database within the cluster.) More
31-
accurately, a database is a collection of schemas and the schemas
32-
contain the tables, functions, etc. So the full hierarchy is:
33-
server, database, schema, table (or some other kind of object,
25+
A small number of objects, like role, database, and tablespace
26+
names, are defined at the cluster level and stored in the
27+
<literal>pg_global</literal> tablespace. Inside the cluster are
28+
multiple databases, which are isolated from each other but can access
29+
cluster-level objects. Inside each database are multiple schemas,
30+
which contain objects like tables and functions. So the full hierarchy
31+
is: cluster, database, schema, table (or some other kind of object,
3432
such as a function).
3533
</para>
3634

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp