Received: from xchange.zambeel.com ([63.89.188.10]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBF1Q4055539; Thu, 14 Dec 2000 20:26:04 -0500 (EST) (envelope-from sjoshi@Zambeel.com) Received: by exchange.zambeel.com with Internet Mail Service (5.5.2650.21) id ; Thu, 14 Dec 2000 17:26:29 -0800 Received: from zambeel.com (sjoshi.zambeel.com [10.0.1.13]) by xchange.zambeel.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id W826MAZ1; Thu, 14 Dec 2000 17:26:21 -0800 From: Sandeep Joshi To: pgsql-hackers@postgresql.org, pgsql-interfaces@postgresql.org, pgsql-general@postgresql.org Message-ID: <3A39733D.245A8FA3@zambeel.com> Date: Thu, 14 Dec 2000 17:26:21 -0800 X-Mailer: Mozilla 4.72 [en] (X11; U; SunOS 5.7 sun4u) X-Accept-Language: en MIME-Version: 1.0 Subject: create trigger : functions Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200012/484 X-Sequence-Number: 1761 Hi, I have written a 'C' function to be called during INSERT trigger on a table. Are there any restrictions on the functions that can be called? I know you can call SPI_* functions. But, can I call PQ* functions ? e.g PQsetdb. Is there any document which describes how the functions written for trigger are executed? Do they executed within the same process as server process or another process is started to execute the commands? regards, Sandeep