| From: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | functions and triggers |
| Date: | 2002-08-20 20:29:45 |
| Message-ID: | 1029875385.3d62a6b9b2522@bugs.unl.edu.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-08-20 21:16:13 | Re: functions and triggers |
| Previous Message | Stephan Szabo | 2002-08-20 17:03:54 | Re: Problem with timestamp field/time function.. (upgrading |