Andrew Dunstan wrote:

>Before we even get there we need agreement on exactly what it means :-)
>
>Seems like the best place for the settings might be pg_hba.conf.
>
>Say we have a new keyword "limit" there. Here are the possibilities (I 
>think):

<snip>

First post (unlurking) here, so just a minor contribution.  I think that 
there is already a LIMIT keyword, ala:

http://www.postgresql.org/docs/7.4/static/queries-limit.html

Since this is more or less a privileges issue, would it be reasonable to
extend the GRANT/REVOKE style syntax (with a different keyword, of course) 
to allow this parameter to be set, just for consistencies sake? This would 
also allow the sysadmin to limit connections on groups as well, if
necessary.  

I'm not sure how you would structure a GRANT/REVOKE style query to include
a numeric parameter so it doesn't look completely out of place, so it's just
an idea...

Best regards,

-David Felstead
This email and any attachments may contain privileged and
confidential information and are intended for the named
addressee only. If you have received this e-mail in error,
please notify the sender and delete this e-mail immediately.
Any confidentiality, privilege or copyright is not waived or
lost because this e-mail has been sent to you in error. It
is your responsibility to check this e-mail and any 
attachments for viruses.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to