Received: from yara.imsd.uni-mainz.de (yara.IMSD.Uni-Mainz.DE [134.93.144.68]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6I90Wa77009 for ; Wed, 18 Jul 2001 05:00:32 -0400 (EDT) (envelope-from wagner@imsd.uni-mainz.de) Received: (from smap@localhost) by yara.imsd.uni-mainz.de (8.9.3/8.9.3/lxs_5.2) id KAA06398 for ; Wed, 18 Jul 2001 10:59:52 +0200 Received: from hermes.imsd.uni-mainz.de(134.93.64.80) by yara.imsd.uni-mainz.de via smap (V2.1/2.1+anti-relay+anti-spam) id xma006387; Wed, 18 Jul 01 10:59:29 +0200 Received: from imsd.uni-mainz.de (unverified [134.93.64.34]) by hermes.imsd.uni-mainz.de (EMWAC SMTPRS 0.83) with SMTP id ; Wed, 18 Jul 2001 10:58:47 +0200 Message-ID: <3B55445B.36E16A4@imsd.uni-mainz.de> Date: Wed, 18 Jul 2001 10:10:03 +0200 From: Markus Wagner Organization: IMSD X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: SPI_exec does not return! Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200107/241 X-Sequence-Number: 4037 Hi, if I do a SELECT on a non-existing table, SPI_exec won't return. I get, e. g. in pgaccess, an error message " does not exist", and my code below the function call is never reached. So why return error codes for SPI_exec when you cannot evaluate them? The background: I need to distinguish different client connections within a trigger function. To do this, I create a temporary table within a "login" function. My trigger must check for the existence of this function. I cannot think of any other method, since there is no "connection id" or something like that! This would also be an application for checking the existance of a temporary table, as was asked for in another thread in this list before. How can I check for the existence of a temporary table without getting interuppted????? Thanks, Markus