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

Commitb2e09fc

Browse files
committed
This is not the only place in the system catalogs where NULL is
effectively used to mean a default value that could also be spelledout explicitly. (ACLs behave that way, and useconfig/datconfigdo too IIRC.)It's a bit of a hack, but it saves table space and backend code ---without this convention the default would have to be inserted "manually"since we have no mechanism to supply defaults when C code is forming anew catalog tuple.I'm inclined to leave the code alone. But Alvaro is right that it'd begood to point out the 'infinity' option in the CREATE USER and ALTERUSER man pages. (Doc patch please?)Alvaro Herrera
1 parent0fe77d7 commitb2e09fc

File tree

1 file changed

+10
-2
lines changed

1 file changed

+10
-2
lines changed

‎doc/src/sgml/ref/alter_user.sgml

Lines changed: 10 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_user.sgml,v 1.24 2003/01/19 00:13:29 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_user.sgml,v 1.25 2003/03/20 20:05:32 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -124,7 +124,8 @@ ALTER USER <replaceable class="PARAMETER">username</replaceable> RESET <replacea
124124
<listitem>
125125
<para>
126126
The date (and, optionally, the time)
127-
at which this user's password is to expire.
127+
at which this user's password is to expire. To set the password
128+
never to expire, use 'infinity'.
128129
</para>
129130
</listitem>
130131
</varlistentry>
@@ -232,6 +233,13 @@ ALTER USER chris VALID UNTIL 'May 4 12:00:00 1998 +1';
232233
</programlisting>
233234
</para>
234235

236+
<para>
237+
Make a user valid forever:
238+
<programlisting>
239+
ALTER USER fred VALID UNTIL 'infinity';
240+
</programlisting>
241+
</para>
242+
235243
<para>
236244
Give a user the ability to create other users and new databases:
237245

0 commit comments

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