Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EB187475BBC for ; Tue, 20 Aug 2002 16:29:56 -0400 (EDT) Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by postgresql.org (Postfix) with ESMTP id 377BD4754A3 for ; Tue, 20 Aug 2002 16:29:56 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id E72F0FDDC for ; Tue, 20 Aug 2002 17:29:47 -0300 (GMT) Received: by bugs.unl.edu.ar (Postfix, from userid 60001) id 06270FCA9; Tue, 20 Aug 2002 17:29:47 -0300 (GMT) Received: from 168.96.132.213 ( [168.96.132.213]) as user martin@bugs.unl.edu.ar by bugs.unl.edu.ar with HTTP; Tue, 20 Aug 2002 17:29:45 -0300 Message-ID: <1029875385.3d62a6b9b2522@bugs.unl.edu.ar> Date: Tue, 20 Aug 2002 17:29:45 -0300 From: Martin Marques To: pgsql-sql@postgresql.org Subject: functions and triggers MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.0 X-Virus-Scanned: by AMaViS snapshot-20020300 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/297 X-Sequence-Number: 9143 I'm trying to build a trigger that will update a timestamp field in a table with the current timestamp, and I just can't make it work. The problemas are two: 1) when I try to create the trigger, it says that the function doesn't exist. Why is this happening? 2) How does the trigger tell the function the row number identifier? I'm really stuck with this. Saludos... :-) -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? ----------------------------------------------------------------- Martín Marqués | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------