 | | From: | Matthias Schmidt | | Subject: | Some things I like to pick from the TODO list ... | | Date: | Tue, 18 Jan 2005 20:15:10 +0100 |
|
|
 | Hi *,
I have some cylcles left and like to pick up something from the TODO
list.
These are the things I'm interested in:
1) Allow limits on per-db/user connections
2) Allow server log information to be output as INSERT statements
3) Allow GRANT/REVOKE permissions to be applied to all schema objects
with one
4) Allow PREPARE of cursors
what's free, what's apropriate for a newbee like me?
cheers,
Matthias
----------------------------------------------------------------------
Matthias Schmidt
Viehtriftstr. 49
67346 Speyer
GERMANY
Tel.: +49 6232 4867
Fax.: +49 6232 640089
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
|
|
| | From: | Stephen Frost | | Subject: | Re: Some things I like to pick from the TODO list ... | | Date: | Tue, 18 Jan 2005 15:23:31 -0500 |
|
|
|
--dBmtbX8ZnVrLmQoo
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
* Matthias Schmidt (schmidtm@mock-software.de) wrote:
> 3) Allow GRANT/REVOKE permissions to be applied to all schema objects=20
> with one
This would be nice. I had to write a perl script to do it here. :)
It'd also be nice to be able to specify a set of permissions that will
be inheirited by newly created objects in a schema. Something like:
grant select,insert,update on schema DEFAULT to group xyz;
Stephen
--dBmtbX8ZnVrLmQoo
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)
iD8DBQFB7XBCrzgMPqB3kigRAgcSAJsG8FlSRthREHIbEmk95RUj3IKMwgCbByU8
sSO1ahRM9r7sRZA1ikVRKmw=
=g8vW
-----END PGP SIGNATURE-----
--dBmtbX8ZnVrLmQoo--
|
|
| | From: | Tom Lane | | Subject: | Re: Some things I like to pick from the TODO list ... | | Date: | Tue, 18 Jan 2005 14:47:20 -0500 |
|
|
| Matthias Schmidt writes:
> These are the things I'm interested in:
> 1) Allow limits on per-db/user connections
> 2) Allow server log information to be output as INSERT statements
> 3) Allow GRANT/REVOKE permissions to be applied to all schema objects
> with one
> 4) Allow PREPARE of cursors
> what's free, what's apropriate for a newbee like me?
I'd vote for #3 just because it'd be much the most useful --- we
get requests for that every other day, it seems like. The others
are far down the wish-list. It's also localized enough that I think
a newbie could handle it.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
|
|
| | From: | Matthias Schmidt | | Subject: | Re: Some things I like to pick from the TODO list ... | | Date: | Thu, 20 Jan 2005 19:22:14 +0100 |
|
|
| OK guys - i think I go for #3:
Allow GRANT/REVOKE permissions to be applied to all schema objects with
one
cheers,
Matthias
Am 18.01.2005 um 20:47 schrieb Tom Lane:
> Matthias Schmidt writes:
>> These are the things I'm interested in:
>
>> 1) Allow limits on per-db/user connections
>> 2) Allow server log information to be output as INSERT statements
>> 3) Allow GRANT/REVOKE permissions to be applied to all schema objects
>> with one
>> 4) Allow PREPARE of cursors
>
>> what's free, what's apropriate for a newbee like me?
>
> I'd vote for #3 just because it'd be much the most useful --- we
> get requests for that every other day, it seems like. The others
> are far down the wish-list. It's also localized enough that I think
> a newbie could handle it.
>
> regards, tom lane
>
>
----------------------------------------------------------------------
Matthias Schmidt
Viehtriftstr. 49
67346 Speyer
GERMANY
Tel.: +49 6232 4867
Fax.: +49 6232 640089
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
|
|
| | From: | Alvaro Herrera | | Subject: | Re: Some things I like to pick from the TODO list ... | | Date: | Tue, 18 Jan 2005 16:23:09 -0300 |
|
|
| On Tue, Jan 18, 2005 at 08:15:10PM +0100, Matthias Schmidt wrote:
> 1) Allow limits on per-db/user connections
Sounds hard to do: what limits? CPU, disk?
> 2) Allow server log information to be output as INSERT statements
Is this really needed?
> 3) Allow GRANT/REVOKE permissions to be applied to all schema objects
> with one
Maybe this is "apply schema changes to several objects with one
command". This seems reasonable.
> 4) Allow PREPARE of cursors
What does this means? Do you use an EXECUTE FETCH afterwards? Doesn't
make a lot of sense to me.
--
Alvaro Herrera ()
"Porque francamente, si para saber manejarse a uno mismo hubiera que
rendir examen... ¿Quién es el machito que tendría carnet?" (Mafalda)
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
|
|
| | From: | Reini Urban | | Subject: | Re: Some things I like to pick from the TODO list ... | | Date: | Tue, 18 Jan 2005 23:30:09 +0100 |
|
|
| Alvaro Herrera schrieb:
> On Tue, Jan 18, 2005 at 08:15:10PM +0100, Matthias Schmidt wrote:
>>1) Allow limits on per-db/user connections
> Sounds hard to do: what limits? CPU, disk?
Note that a typical server limit, the load average, will not be
portable. There's no WIN32 solution yet.
The CPU load is also not really easy to port, but there exist solutions.
But I guess you are only talking about restricting client connections,
which is easy enough.
--
Reini Urban
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
|
|
