From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
---|---|
To: | "Aasmund Midttun Godal" <postgresql(at)envisity(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: PL/pgSQL examples NOT involving functions |
Date: | 2001-11-27 01:23:13 |
Message-ID: | web-513889@davinci.ethosmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-sql |
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(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Padgaonkar | 2001-11-27 07:10:47 | Cant load pgtclsh library into application |
Previous Message | Bruce Momjian | 2001-11-26 21:01:52 | Re: Privileges description not reflecting 7.2 enhancements |
From | Date | Subject | |
---|---|---|---|
Next Message | Gyorgy Molnar | 2001-11-27 14:11:18 | Queue in SQL |
Previous Message | Nicole S. Weber | 2001-11-26 23:03:56 | count(*) - join question |