I am running PostgreSQL 7.0.2 and AOLserver 3.2+ad10. Both installed from tarball and compiled (PostgreSQL with TCL). I'll try out your
suggestion and post results here. But I am wondering: the file
postgres-pgtcl.sql is not loaded during normal install (because
functions defined there are TCL functions, and normal installation
comes with pgsql as the only language). Is it a leftover from
previous version?
There is also another weird thing: after seeing that dump/restore
does not solve my problem, I removed all TCL functions from the dump
file and restored from it once more. Did not help, either. But I am
sure it worked before. Now I have search in forums (great!) but can
not run statistics. If only that, but I guess it will generate server errors elsewhere, where any of these date functions is used.
Since my installation has already some users, reinstalling
the stuff from scratch is not what I want to do. But I wonder about
dumps -- anytime I restore from them, I get a few errors. Is
pg_dumpall a better solution? Or am I the only one having problems
with that?
I'll appreciate any reply.
