Received: from mx2.datanet.hu (unknown [194.149.13.163]) by postgresql.org (Postfix) with ESMTP id A730B475957 for ; Wed, 3 Apr 2002 22:40:26 -0500 (EST) Received: from mithrandir.hu (tiszaujvaros2-2.dialin.datanet.hu [195.56.11.193]) by mx2.datanet.hu (DataNet) with ESMTP id A8E795AA7; Thu, 4 Apr 2002 05:40:29 +0200 (CEST) Message-ID: <3CABCB62.6E94216@mithrandir.hu> Date: Thu, 04 Apr 2002 05:41:22 +0200 From: =?iso-8859-2?Q?Ikl=F3di?= Lajos X-Mailer: Mozilla 4.51 [hu] (WinNT; I) X-Accept-Language: hu MIME-Version: 1.0 To: Jan Wieck Cc: "pgsql-sql@postgresql.org" , William Meloney Subject: Re: Update in trigger References: <200204031644.g33Gixc32234@saturn.janwieck.net> Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 8bit X-Archive-Number: 200204/47 X-Sequence-Number: 7312 Hi, Jan Wieck írta: > Are there appropriate indexes on the table updated in the > trigger and is the database "VACUUM ANALYZE"ed so the indexes > get used? There is a primary key. VACUUM ANALYZE is really helpful, but only for a few minutes (3000 inserted records). William Meloney írta: > Please forward a copy of the trigger. This is exactly the same thing I > am trying to do but I have not had any success. Here is the whole structure: CREATE TABLE nyadat ( nykod serial primary key, nymekod int4 not null references mekonf, nyatip int4 not null references nyatip, nymeido timestamp, nytarido timestamp default now(), nyhossz int4, nyadat bytea ) ; CREATE TABLE szm ( kod serial primary key, konfx int4, csatx int4, dparx int4, nparx int4, nyugtax int4, parancsx int4, esemenyx int4, kalibrx int4, nyx int4, feldx int4, kparx int4 ) ; create function nyx_fnc() returns opaque as ' begin update szm set nyx = new.nykod where kod=1 ; return new ; end ; ' language 'plpgsql' ; create trigger ny_x_trig after insert on nyadat for each row execute procedure nyx_fnc() ; Thanks for any help. Lajos