Alvaro Herrera wrote:
>I don't think this approach is very user-friendly. I'd vote for the
>catalog approach, I think.
>
>
Ok I am fine with both but catalog changes would mean more hacking of
ALTER DATABASE and ALTER USER.
>Maybe you could make some checks against the shared array of PGPROCs
>(procarray.c), for the per-database limit at least. Not sure about
>per-user limit.
>
>
Thats good idea (I could maybe add userid to PGPROC struct too) but I
think there could be problem with two phase commits because they add new
entry to that array of PGPROCs too and I don't kow if we want to include
them to that limit.
--
Regards
Petr Jelinek (PJMODOS)