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

Matthias Schmidt <schmidtm@mock-software.de> 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

* Matthias Schmidt (schmidtm@mock-software.de) wrote:
> 3) Allow GRANT/REVOKE permissions to be applied to all schema objects
> 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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)

iD8DBQFB7XBCrzgMPqB3kigRAgcSAJsG8FlSRthREHIbEmk95R Uj3IKMwgCbByU8
sSO1ahRM9r7sRZA1ikVRKmw=
=g8vW
-----END PGP SIGNATURE-----

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

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 <schmidtm@mock-software.de> 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