On 10/14/2005 09:30:51 AM, Michael Fuhr wrote:
On Thu, Oct 13, 2005 at 03:51:15PM +0000, Karl O. Pinc wrote:
> I definately do not recall catching any additional errors at
> compile time as part of the switch to 8.
8.0's syntax checking is minimal; 8.1's will be better.
Looking forward to it!
Also, you
might not even have plpgsql's lanvalidator function if you restored
from an earlier version. What's the result of the following query?
SELECT * FROM pg_language WHERE lanname = 'plpgsql';
If lanvalidator is 0 then you won't get even the minimal syntax
checks. 8.1 will avoid this problem by creating languages based
on entries in a template table (pg_pltemplate).
babase=# SELECT * FROM pg_language WHERE lanname = 'plpgsql';
lanname | lanispl | lanpltrusted | lanplcallfoid | lanvalidator |
lanacl
---------+---------+--------------+---------------+--------------+--------
plpgsql | t | t | 17239 | 17240 |
(1 row)
So I've got it.
IIRC I didn't have anything but test data at the time I upgraded
to 8.0 and so re-created all my databases.
Karl <[EMAIL PROTECTED]>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
