Re: ALTER USER - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ALTER USER
Date
Msg-id 21137.1047836185@sss.pgh.pa.us
Whole thread Raw
In response to Re: ALTER USER  (Rod Taylor <rbt@rbt.ca>)
Responses Re: ALTER USER
Re: ALTER USER
List pgsql-hackers
Rod Taylor <rbt@rbt.ca> writes:
> It may be worth while to change the default for valuntil to be
> 'infinity'.  NULL implies they will expire, we're just not sure when.

This is not the only place in the system catalogs where NULL is
effectively used to mean a default value that could also be spelled
out explicitly.  (ACLs behave that way, and useconfig/datconfig
do 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 a
new catalog tuple.

I'm inclined to leave the code alone.  But Alvaro is right that it'd be
good to point out the 'infinity' option in the CREATE USER and ALTER
USER man pages.  (Doc patch please?)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: ALTER USER
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] Upgrading the backend's error-message infrastructure