Wrowser and Postgresql 9.4
Hello,
I've installed the Wroser, however I am encountering several problems while running the scripts needed to create the simdb database and to create the user for the database.
Any suggestions on how to adapt the scripts for Postgresql 9.4 ?
The errors are pasted here below.
Thanks in advance for the help.
Kind regards.
-------
$ psql -U postgres -d simdb -f setupSimDB.sql
Password for user postgres:
psql:setupSimDB
..
psql:setupSimDB
LINE 11: ...ELECT pg_total_
psql:setupSimDB
..
psql:setupSimDB
LINE 95: type_string text DEFAULT \'\'
CREATE FUNCTION
ALTER FUNCTION
psql:setupSimDB
-------
$ ./createUser.py
Local installation of wrowser found.
Please enter the password of the 'postgres' super user:
Traceback (most recent call last):
File "./createUser.py", line 75, in <module>
curs.
psycopg2.
LINE 1: SELECT administration.
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: SELECT administration.
CONTEXT: PL/pgSQL function users() line 16 at PERFORM
fmiatton@
fmiatton@
Local installation of wrowser found.
Prepending /home/fmiatton/
Please enter the password of the 'postgres' super user:
Traceback (most recent call last):
File "./createUser.py", line 75, in <module>
curs.
psycopg2.
LINE 1: SELECT administration.
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: SELECT administration.
CONTEXT: PL/pgSQL function users() line 16 at PERFORM
Question information
- Language:
- English Edit question
- Status:
- Solved
- Assignee:
- No assignee Edit question
- Solved by:
- Omai bigee
- Solved:
- Last query:
- Last reply: