Courses
Sections
Projects
Wiki
News
Forums
Surveys
Mailing Lists| Author | Message |
|---|---|
|
alomo
Posts: 70
|
Posted 13:54 Apr 08, 2010 |
Does anybody get the following error when populating the database with the file csns-create.sql? ERROR: language "plpgsql" does not exist |
|
cysun
Posts: 2935
|
Posted 14:37 Apr 08, 2010 |
plpgsql is the language used by the stored procedures. It should be installed by default. What's your platform and which installer did you use? |
|
alomo
Posts: 70
|
Posted 15:33 Apr 08, 2010 |
It is Windows7, and I used installer postgresql-8.4.1-1-windows (the pgAdmin version is 1.10.0).
I installed it with no errors. The only difference from the installation shown in the video was the skipped step when I could select components to be installed. Then I created the new role and the database for that role.
The error appeared when I tried to run the csns-create.sql script.
Last edited by alomo at
15:35 Apr 08, 2010.
|
|
cysun
Posts: 2935
|
Posted 15:45 Apr 08, 2010 |
Connect to the database CSNS and execute the following statement:
You can also connect to the database template1 and execute the same statement, and after that all the databases you create in the future will have plpgsql installed. |
|
alomo
Posts: 70
|
Posted 17:24 Apr 08, 2010 |
Actually, I removed existing database and created it again and there is no error. I guess I was selecting wrong template when created the database. Thank you. Last edited by alomo at
17:24 Apr 08, 2010.
|
