Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id fAR1NHm42168
	for <pgsql-sql@postgresql.org>; Mon, 26 Nov 2001 20:23:17 -0500 (EST)
	(envelope-from josh@agliodbs.com)
Received: from [209.10.40.250] (account <josh@agliodbs.com>)
	by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.7)
	with HTTP id 513889; Mon, 26 Nov 2001 17:23:13 -0800
From: "Josh Berkus" <josh@agliodbs.com>
Subject: Re: PL/pgSQL examples NOT involving functions
To: "Aasmund Midttun Godal" <postgresql@envisity.com>
Cc: pgsql-sql@postgresql.org
X-Mailer: CommuniGate Pro Web Mailer v.3.4.7
Date: Mon, 26 Nov 2001 17:23:13 -0800
Message-ID: <web-513889@davinci.ethosmedia.com>
In-Reply-To: <20011123144723.6250.qmail@ns.krot.org>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200111/365
X-Sequence-Number: 5747

Aasmund,

> Well - it is not 'compiled' until the first time you run it - this is
> so that it will work with circular dependancies. I am not sure how
> much it compiles it, but I think it at least stores parse-trees,
> because if you drop a table and recreate it and run the same function
> on it, it will cause an error a la 'can't find relation 11312'.

This is incorrect.  This happens with views, but not with functions.

-Josh


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco