Problem in creating the database
When I run the following command:
psql -U postgres -d simdb -f setupSimDB.sql
With psql version 9.4.6 I encounter the following problem.
ALTER FUNCTION
psql:setupSimDB
LINE 11: ...ELECT pg_total_
psql:setupSimDB
CREATE FUNCTION
ALTER FUNCTION
CREATE FUNCTION
ALTER FUNCTION
CREATE FUNCTION
ALTER FUNCTION
GRANT
CREATE FUNCTION
CREATE FUNCTION
SET
psql:setupSimDB
LINE 95: type_string text DEFAULT \'\'
Any suggestions?
Thanks in advance.
Question information
- Language:
- English Edit question
- Status:
- Solved
- Assignee:
- No assignee Edit question
- Solved by:
- Maciej Muehleisen
- Solved:
- 2016-02-29
- Last query:
- 2016-02-29
- Last reply:
- 2016-02-23
Please uninstall PSQL 9 and use PSQL 8 as described here under Ubuntu 12.04 (also works for 14.04, not tried with newer versions):
http://
Sometimes there are problems deinstalling PSQL 9. You then might want to start over with a fresh system. This might also help:
Omai bigee (o-maib-g) said : | #2 |
Indeed I somehow skipped reading the line saying that PSQL9 was not supported.
As per my experience, Debian 8 with Postgresql 9 definitely does NOT work.
I started again with Ubuntu 12.04 and everything worked fine.
Thanks a lot for your help!
Omai bigee (o-maib-g) said : | #3 |
Thanks Maciej Muehleisen, that solved my question.