X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id ED3A0CCFC8 for ; Sat, 19 Jul 2003 14:23:31 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 17984-04 for ; Sat, 19 Jul 2003 14:23:52 +0000 (GMT) Received: from acheron.rime.com.au (acheron.rhyme.com.au [203.208.66.49]) by svr1.postgresql.org (Postfix) with ESMTP id 1E0E0CCFAD for ; Sat, 19 Jul 2003 11:23:20 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by acheron.rime.com.au (Postfix on SuSE Linux 8.0 (i386)) with ESMTP id C6DC567CC7; Sun, 20 Jul 2003 00:23:53 +1000 (EST) Received: by acheron.rime.com.au (Postfix on SuSE Linux 8.0 (i386), from userid 527) id AE06867CC8; Sun, 20 Jul 2003 00:23:52 +1000 (EST) Received: from hephaestus.rhyme.com.au (unknown [203.8.195.124]) by acheron.rime.com.au (Postfix on SuSE Linux 8.0 (i386)) with ESMTP id 94C4967CC7; Sun, 20 Jul 2003 00:23:51 +1000 (EST) Message-Id: <5.1.0.14.0.20030720002233.024d0568@mail.rhyme.com.au> X-Sender: pjw@mail.rhyme.com.au X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Sun, 20 Jul 2003 00:23:51 +1000 To: Reinoud van Leeuwen , pgsql-hackers@postgresql.org From: Philip Warner Subject: Re: plpgsql strangeness with select into In-Reply-To: <20030718172452.L54220@spoetnik.xs4all.nl> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by AMaViS 0.3.12pre8 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/447 X-Sequence-Number: 41052 At 05:24 PM 18/07/2003 +0200, Reinoud van Leeuwen wrote: >Does anyone have a clue what is going wrong? I use Postgresql 7.3.3 on >FreeBSD 4.5. Is it a before or after trigger. If 'before', are you trying to reference data that does not exist yet? ---------------------------------------------------------------- Philip Warner | __---_____ Albatross Consulting Pty. Ltd. |----/ - \ (A.B.N. 75 008 659 498) | /(@) ______---_ Tel: (+61) 0500 83 82 81 | _________ \ Fax: (+61) 03 5330 3172 | ___________ | Http://www.rhyme.com.au | / \| | --________-- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/