Re: [GENERAL] default grant

2010-04-07 Thread Ing. Marcos Ortiz Valmaseda
Sim Zacks escribió: I forgot to mention I'm using 8.2 On 4/7/2010 1:40 PM, Sim Zacks wrote: Is there a way to grant permissions on any new objects (or at least new tables) to a role? In my app I have a function that drops and recreates a table at certain times (with a different structure).

Re: [PERFORM] [GENERAL] Strange performance degradation

2009-11-24 Thread Ing. Marcos Ortiz Valmaseda
Lorenzo Allegrucci escribió: Matthew Wakeling wrote: On Mon, 23 Nov 2009, Lorenzo Allegrucci wrote: Anyway, how can I get rid those "idle in transaction" processes? Can I just kill -15 them or is there a less drastic way to do it? Are you crazy? Sure, if you want to destroy all of the changes