On Fri, Jun 4, 2010 at 10:24 PM, mnavahan <mnavahan@xxxxxxxxx> wrote: > > > > Scott Marlowe-2 wrote: >> >> On Wed, May 19, 2010 at 10:38 AM, mnavahan <mnavahan@xxxxxxxxx> wrote: >>> >>>>>I think so. Look up "SECURITY DEFINER" >>> >>> seems goods .... i need try to it ... >>> >>> >>>>>Not that I know of. You're talking connect / disconnect triggers right? >>> YES .... how do it ? >> >> It's not really doable. However, it's possible that what you're >> trying to accomplish (big picture) is. What is it that you're trying >> to accomplish with connect / disconnect triggers? >> >> > > > yes really need it ! > also need for transaction ! OK, but what do you need it to do, why are you doing it? I can't offer possible alternatives if I don't know why you're trying to do it. Do you want the user to have certain schemas in their search path? Set values for random_page_cost? Set logging to a certain level? All of those things can be done without a trigger. Are you wanting to log access from a user? More detail gets better answers. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
