Re: TCL trigger doesn't work after deleting a column - Mailing list pgsql-general

Tom,

This is my table definition:

-- Table: public.tinv

-- DROP TABLE public.tinv;

CREATE TABLE public.tinv
(
   dep_codigo varchar(6) NOT NULL,
   dep_nombre varchar(35),
   dep_cantid int4,
   dep_fecadq date,
   dep_vidaut int4,
   dep_pordep int4,
   dep_valdep float4,
   dep_acumul float4,
   dep_tipo int4,
   duser char(10),
   costod numeric(12,4),
   modelo varchar(30),
   serie varchar(30),
   marca varchar(30),
   descrialt varchar(255),
   notes varchar(255),
   deprecia numeric(1),
   valoraseg numeric(12,4),
   downer char(40),
   dfoto varchar(40),
   tienda char(1) DEFAULT '1',
   store numeric(1) DEFAULT 1,
   jobdep_fk char(2),
   taction text,
   dep_valadq numeric(12,4)
) WITH OIDS;


Could you please try it?

Thanks.