severity 369516 wishlist retitle 369516 sql-ledger: should automatically add plpgsql support to postgresql at installation time thanks
Hi, On Tue, 30 May 2006, root wrote: > I have installed sql-ledger on debian etch (2.6.10) I also have installed > postresql-8.1 > > After pointing my browser to http://localhost/sql-ledger/admin.pl I get the > following Errors > when trying to create the database. > > Error! [...] > HINT: Use CREATE LANGUAGE to load the language into the database. > > after that error I issued the command > createlang --dbname=sqlledger --username=postgres pgpsql > and pushed the reload button on the browser. But then I got: > > Error! > CREATE SEQUENCE id start 10000 > ERROR: relation "id" already exists > > how do I fix this error? Remove the database instead of trying to create a new database over a previously failed one... su posqtgres -c "dropdb sqlledger" Then add plpgsql support to the template1 database: createlang --dbname=template1 --username=postgres pgpsql And then restart the DB creation process within sql-ledger. This bug report is a user mistake and not a bug of the package. However I acknowledge that the package should be more user-friendly and it should automatically add support of plpgsql to any available postgresql in its postinst script. The "nice" solution would be for sql-ledger to automatically add plpgsql support on the sql-ledger database only but I don't think that this is possible since sql-ledger runs as www-data. Cheers, -- Raphaël Hertzog Premier livre français sur Debian GNU/Linux : http://www.ouaza.com/livre/admin-debian/
