On Jan 9, 2008 2:46 AM, Robin Vossen <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> I am trying to get Ledger Installed on my Box.
> 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?
>
createlang -d ledgersmb -U postgres plpgsql;
Languages can only be created by superusers. Which version of PostgreSQL
are you running?
>
> Also id like to know, is there something like phpmyadmin for postgresql?
>
Yes. phppgadmin, but if you control the server, you might like PgAdmin III
better (it is a GUI program).
Best Wishes,
Chris Travers
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
