Ah I am at the part now where I should make a Dataset..
When i do Default or any other language I get:
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
psql:sql/Pg-database.sql:825: ERROR: language "plpgsql" does not exist
HINT: You need to use "createlang" to load the language into the database.
psql:sql/Pg-database.sql:828: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:836: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:839: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:841: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:843: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:845: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:855: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:858: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:868: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:871: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:929: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:932: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:935: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:938: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:960: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:963: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:989: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:992: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:994: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:996: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:998: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:1008: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:1010: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:sql/Pg-database.sql:1012: ERROR: current transaction is aborted, commands ignored until end of transaction block
So I thought lets add the language I miss.
doing:
createlang -d ledgersmb -U ledgersmb plpgsql
I keep getting:
createlang: language installation failed: ERROR: permission denied for language c
how to fix?
Also id like to know, is there something like phpmyadmin for postgresql?
Thanks,
Cheers,
Robin