Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 95B27643C56 for ; Mon, 15 Mar 2010 17:57:25 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 21705-02-5 for ; Mon, 15 Mar 2010 20:57:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx3.uci.cu (ns3.uci.cu [200.55.140.180]) by mail.postgresql.org (Postfix) with SMTP id 4A83765A691 for ; Mon, 15 Mar 2010 17:15:23 -0300 (ADT) Received: (qmail 4207 invoked by uid 507); 15 Mar 2010 20:15:14 -0000 Received: from 10.0.0.184 by ns3.uci.cu (envelope-from , uid 501) with qmail-scanner-2.01st (avp: 5.0.2.0. spamassassin: 3.0.6. perlscan: 2.01st. Clear:RC:1(10.0.0.184):. Processed in 0.72816 secs); 15 Mar 2010 20:15:14 -0000 Received: from unknown (HELO ucimail3.uci.cu) (10.0.0.184) by 0 with SMTP; 15 Mar 2010 20:15:13 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by ucimail3.uci.cu (Postfix) with ESMTP id 7AEFDB48E2B; Mon, 15 Mar 2010 16:15:13 -0400 (CDT) X-Virus-Scanned: amavisd-new at uci.cu Received: from ucimail3.uci.cu ([127.0.0.1]) by localhost (ucimail3.uci.cu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 9AVF60WJGE7P; Mon, 15 Mar 2010 16:15:12 -0400 (CDT) Received: from [10.36.18.44] (unknown [10.36.18.44]) by ucimail3.uci.cu (Postfix) with ESMTP id 8AA1C1E8C01C; Mon, 15 Mar 2010 16:15:12 -0400 (CDT) Message-ID: <4B9E9668.8020408@uci.cu> Date: Mon, 15 Mar 2010 16:19:52 -0400 From: "Ing. Marcos Ortiz Valmaseda" User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: John Dizaro CC: pgsql-sql@postgresql.org Subject: Re: I, nead to capture the IP number from the PC how is running the script ... References: <11c2d5211003151218y4ce9218du20034785a8103c39@mail.gmail.com> In-Reply-To: <11c2d5211003151218y4ce9218du20034785a8103c39@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=AWL=0.186, BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 201003/90 X-Sequence-Number: 33797 John Dizaro escribió: > I, nead to capture the IP number from the PC how is running the script > "update TABLE1 set campo1 = 123 where ...; " > Can someone help me please? > > > -- > John Evan Dizaro - > Fone: (41) 3333-0303 > Fone: (41) 9243-3240 > Rua: Alferes Poli Curitiba - PR - Brasil inet_client_addr(): inet address of the client inet_client_port(): client''s port number for this connection Regards -- -------------------------------------------------------- -- Ing. Marcos Luís Ortíz Valmaseda -- -- Twitter: http://twitter.com/@marcosluis2186 -- -- FreeBSD Fan/User -- -- http://www.freebsd.org/es -- -- Linux User # 418229 -- -- Database Architect/Administrator -- -- PostgreSQL RDBMS -- -- http://www.postgresql.org -- -- http://planetpostgresql.org -- -- http://www.postgresql-es.org -- -------------------------------------------------------- -- Data WareHouse -- Business Intelligence Apprentice -- -- http://www.tdwi.org -- -------------------------------------------------------- -- Ruby on Rails Fan/Developer -- -- http://rubyonrails.org -- -------------------------------------------------------- Comunidad Técnica Cubana de PostgreSQL http://postgresql.uci.cu http://personas.grm.uci.cu/+marcos Centro de Tecnologías de Gestión de Datos (DATEC) Contacto: Correo: centalad@uci.cu Telf: +53 07-837-3737 +53 07-837-3714 Universidad de las Ciencias Informáticas http://www.uci.cu