Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB6Fsot31430 for ; Wed, 6 Dec 2000 10:54:50 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id eB6FswY06967; Wed, 6 Dec 2000 10:54:58 -0500 (EST) To: Bruno Boettcher cc: pgsql-sql@postgresql.org Subject: Re: what's wrong with my plperl function? In-reply-to: <20001206130158.A7713@erm1.u-strasbg.fr> References: <20001206130158.A7713@erm1.u-strasbg.fr> Comments: In-reply-to Bruno Boettcher message dated "Wed, 06 Dec 2000 13:01:58 +0100" Date: Wed, 06 Dec 2000 10:54:58 -0500 Message-ID: <6964.976118098@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200012/39 X-Sequence-Number: 370 Bruno Boettcher writes: > so what am i doing wrong? I'm confused too... > besides how can i output debug stuff from the > perl script? print manifestingly doesn't work... I don't see why print wouldn't work. Realize however that it will go to the postmaster's stdout, so you'd better not have started the postmaster with -S, and you should have redirected the postmaster's stdout/stderr into a log file someplace. You might have better luck printing to stderr, BTW ... that should get flushed to the disk file once per line, whereas Perl might think it only needs to flush stdout once per block. Also, it looks like plperl supports elog(NOTICE, "text") and elog(ERROR, "text"), though I haven't tried 'em. regards, tom lane