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

Commitfee590c

Browse files
committed
Update for roles:
< * Allow limits on per-db/user connections> * Allow limits on per-db/role connections< * Prevent default re-use of sysids for dropped users and roles<< Currently, if a user is removed while he still owns objects, a new< user given might be given their user id and inherit the< previous users objects.<450c444< * Add COMMENT ON for all cluster global objects (users, roles, databases> * Add COMMENT ON for all cluster global objects (roles, databases609c603< users and roles with separate DROP commands> roles with separate DROP commands
1 parentb00f557 commitfee590c

File tree

2 files changed

+8
-19
lines changed

2 files changed

+8
-19
lines changed

‎doc/TODO

Lines changed: 4 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)
5-
Last updated:Fri Jul 1 13:05:46 EDT 2005
5+
Last updated:Fri Jul 1 13:32:12 EDT 2005
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -21,18 +21,12 @@ Administration
2121

2222
* Remove behavior of postmaster -o after making postmaster/postgres
2323
flags unique
24-
* Allow limits on per-db/user connections
24+
* Allow limits on per-db/role connections
2525
* Allow server log information to be output as INSERT statements
2626

2727
This would allow server log information to be easily loaded into
2828
a database for analysis.
2929

30-
* Prevent default re-use of sysids for dropped users and roles
31-
32-
Currently, if a user is removed while he still owns objects, a new
33-
user given might be given their user id and inherit the
34-
previous users objects.
35-
3630
* Prevent dropping user that still owns objects, or auto-drop the objects
3731
* Allow pooled connections to list all prepared queries
3832

@@ -447,7 +441,7 @@ Commands
447441
* Add ON COMMIT capability to CREATE TABLE AS SELECT
448442
* Add NOVICE output level for helpful messages like automatic sequence/index
449443
creation
450-
* Add COMMENT ON for all cluster global objects (users,roles, databases
444+
* Add COMMENT ON for all cluster global objects (roles, databases
451445
and tablespaces)
452446
* Add an option to automatically use savepoints for each statement in a
453447
multi-statement transaction.
@@ -606,7 +600,7 @@ Clients
606600
o Add dumping of comments on composite type columns
607601
o Add dumping of comments on index columns
608602
o Replace crude DELETE FROM method of pg_dumpall for cleaning of
609-
users androles with separate DROP commands
603+
roles with separate DROP commands
610604
o -Add dumping and restoring of LOB comments
611605
o Stop dumping CASCADE on DROP TYPE commands in clean mode
612606
o Add full object name to the tag field. eg. for operators we need

‎doc/src/FAQ/TODO.html

Lines changed: 4 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">
99
<h1><aname="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<ahref="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>
11-
Last updated: Fri Jul 1 13:05:46 EDT 2005
11+
Last updated: Fri Jul 1 13:32:12 EDT 2005
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -26,15 +26,10 @@ <h1><a name="section_2">Administration</a></h1>
2626
<ul>
2727
<li>Remove behavior of postmaster -o after making postmaster/postgres
2828
flags unique
29-
</li><li>Allow limits on per-db/user connections
29+
</li><li>Allow limits on per-db/role connections
3030
</li><li>Allow server log information to be output as INSERT statements
3131
<p> This would allow server log information to be easily loaded into
3232
a database for analysis.
33-
</p>
34-
</li><li>Prevent default re-use of sysids for dropped users and roles
35-
<p> Currently, if a user is removed while he still owns objects, a new
36-
user given might be given their user id and inherit the
37-
previous users objects.
3833
</p>
3934
</li><li>Prevent dropping user that still owns objects, or auto-drop the objects
4035
</li><li>Allow pooled connections to list all prepared queries
@@ -413,7 +408,7 @@ <h1><a name="section_7">Commands</a></h1>
413408
</li><li>Add ON COMMIT capability to CREATE TABLE AS SELECT
414409
</li><li>Add NOVICE output level for helpful messages like automatic sequence/index
415410
creation
416-
</li><li>Add COMMENT ON for all cluster global objects (users,roles, databases
411+
</li><li>Add COMMENT ON for all cluster global objects (roles, databases
417412
and tablespaces)
418413
</li><li>Add an option to automatically use savepoints for each statement in a
419414
multi-statement transaction.
@@ -562,7 +557,7 @@ <h1><a name="section_8">Clients</a></h1>
562557
</li><li>Add dumping of comments on composite type columns
563558
</li><li>Add dumping of comments on index columns
564559
</li><li>Replace crude DELETE FROM method of pg_dumpall for cleaning of
565-
users androles with separate DROP commands
560+
roles with separate DROP commands
566561
</li><li>-<em>Add dumping and restoring of LOB comments</em>
567562
</li><li>Stop dumping CASCADE on DROP TYPE commands in clean mode
568563
</li><li>Add full object name to the tag field. eg. for operators we need

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp