I ran into this problem a couple of days ago when I upgraded from 7.0.3 to 7.4.1.
I used the 7.4.1 pg_dumpall, but it created a dump file which tried to load the old
plpgsql.so.
I had to fix the dump file manually before loading it into the new db. There were some
other annoyances too, like the 7.4.1 pg_dumpall dumping out CR in the file, and then
the 7.4.1. psql comlained about it and told me to use \r instead... I had to take out
the "LOCATION" in create database too because it complained about "no such environment
variable". I guess pg_dumpall doesn't understand the differences between the different
versions, so you always have to check the dump file manually if you are changing
version.
/M
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 21, 2004 11:29 PM
Subject: [GENERAL] Lost plpgsql function
> After copied pg database from one PC to another
>
> -I could not find plpgsql function(s) in the copied database.
> -had to instal plpgsql language handler again
>
> -whilst tables and data moved fine
>
> The copy included all under /cygwin/usr/local/pgsql/data and database was
> down while making a copy.
>
>
> What could I forget to copy as far plpgsql is concerned ?
> Are pgsql stored objects stored in the database itself (a table pg_proc,
> column prosrc)?
> Catalog tables like pg_proc are just a part of database cluster data files,
> aren't they?
>
> Thank you in advance, Laimis
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
>
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
