Re: Ayuda con trigger.

From: Jose María Mencía <jmencia(at)alimarket(dot)es>
To: Pablo Braulio <brulics(at)gmail(dot)com>
Cc: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: Ayuda con trigger.
Date: 2005-12-23 08:05:09
Message-ID: 1135325109.3967.1.camel@jmencia
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

> create or replace function proc_auditoria() returns trigger as '
> begin
> if (tg_op = "DELETE") then
> insert into auditoria select current_user, current_date, current_time,
> "DELETE", old.*;

Creo que debes usar comillas simples:

insert into auditoria ...... 'DELETE', old.* ...

In response to

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Antonio 2005-12-23 11:56:34 Re: Inquietud sobre PG_DUMP
Previous Message Pablo Braulio 2005-12-23 07:43:47 Ayuda con trigger.