Thanks Magnus, I have working my triggers, just with 127.0.0.1, soon I'll make tests with LAN clients.
Best regards. Magnus Hagander <[EMAIL PROTECTED]> escribió: On Thu, Apr 05, 2007 at 07:57:41AM -0500, J. ORIOL wrote: > Hello, > > I was in the archives, looking for some concrete info about > inet_client_addr() use, but only a C function found. > > I have some clients to my app. (PG 8.2 in XP LAN). I want to generate > auto-logs with trigger function for every table and for every event, but I > cannot include clint ip address yet. > > When the triggers starts and execute SELECT inet_client_addr(), will > retrieve client's ip ?? or just 127.0.0.1 It should return the clients IP. (If you're using say a web-ap, that will be 127.0.0.1, since it can't know where the browser is. But if the client does a direct connection to the database, it should return it) //Magnus ---------------------- J. Oriol Mujica F. ---------------------- Bucaramanga - COLOMBIA __________________________________________________ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.espanol.yahoo.com/
