X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1E9E49FB35D for ; Fri, 14 Jul 2006 12:08:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 29208-06 for ; Fri, 14 Jul 2006 12:08:07 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by postgresql.org (Postfix) with ESMTP id 2696A9FB334 for ; Fri, 14 Jul 2006 12:08:06 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j40so804043ugd for ; Fri, 14 Jul 2006 08:08:05 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=EderonHqRQy1c/KWqudBaTxzJAQRNWCvFV4zTKH9NZQIRl3tRB0o9yMxek71wsW9xOOSYGbGuTBTLiSkBysRwn6DfW8gi1W2mVvKvm5ALT2xQR5BaGDJUrAoQDFE4BLJ6XpqOGHhw/1ij1a3bbkVm4Ge3VjazRq8nXNu7bm6RKA= Received: by 10.67.101.8 with SMTP id d8mr1325355ugm; Fri, 14 Jul 2006 08:08:05 -0700 (PDT) Received: by 10.67.98.7 with HTTP; Fri, 14 Jul 2006 08:08:05 -0700 (PDT) Message-ID: <36e682920607140808q1e421c8ej8437bbdd89d61203@mail.gmail.com> Date: Fri, 14 Jul 2006 11:08:05 -0400 From: "Jonah H. Harris" To: "Donald Fraser" Subject: Re: hooks for User login process Cc: "[ADMIN]" In-Reply-To: <003d01c6a73e$1bd606a0$0264a8c0@demolish1> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <003d01c6a73e$1bd606a0$0264a8c0@demolish1> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/115 X-Sequence-Number: 22361 On 7/14/06, Donald Fraser wrote: > Is there a mechanism for attaching a trigger function, or the likes, to be > activated when a user logs into the PostgreSQL database? > I'm looking for a means of performing additional house keeping tasks when a > user logs in. A patch currently exists at http://gorda.di.uminho.pt/community/pgsqlhooks/ -- Jonah H. Harris, Software Architect | phone: 732.331.1300 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 2nd Floor | jharris@enterprisedb.com Iselin, New Jersey 08830 | http://www.enterprisedb.com/