Re: [SL] Upgrade problem

[Roy W P. <arc...@mt...>]

Unfortunately Createlang does not allow you to specify the postgresql username 
so it uses the username you are logged in as. In your case.... root.
Since root is not a postgresql user in your configuration, you get the error.


You have 2 choices.

Either install the plpgsql language handler  manually as explained in the 
postgresql docs.

or

when logged in as root...

"su  postgres" 


and then use the 
"createlang plpgsql template1"
"createlang plpgsql Standard"
"createlang plpgsql test"

An import note that some people don't realize is that the template1 database 
is exactly that..... a template.
Anytime you create a new database, postgresql makes a copy of the  template1 
database.


Cheers,
Roy