Should go to devel list as well
----- Forwarded Message ---- From: Phil Longstaff <plongst...@rogers.com> To: gnucash-list <gnucash-u...@lists.gnucash.org> Sent: Monday, June 1, 2009 10:26:45 AM Subject: Re: Re: gnucash-2.3 + sql backend This should be fixed for 2.3.1. For postgres, if the db did not exist, it didn't create it (and unfortunately, didn't indicate "no such db"). For 2.3.1, it will create the db, but will also, of course, require that the user have enough privilege to create a database. With this change in 2.3.1, it will also pop up a "the db is not empty, do you want to overwrite it" dialog box, and if you say yes, it will log some messages in the gnucash.trace log file. There is an issue in libdbi that returns some virtual tables from a postgres db (the postgres db engine makes these tables visible in each db, and libdbi doesn't provide any way of screening them out). It is currently being sorted out on the libdbi devel mailing list whether a new api will be added, or whether gnucash should just ignore these virtual tables. Eventually, gc might want to make use of the info in the tables (it provides information on the db server's sql capabilities). Phil ________________________________ From: Klaus Dahlke <klaus.dah...@gmx.de> To: gnucash-list <gnucash-u...@lists.gnucash.org> Sent: Monday, June 1, 2009 5:48:14 AM Subject: Fw: Re: gnucash-2.3 + sql backend Hi, sorry forget to send to mailing list as well. Cheersm Klaus On Mon, 25 May 2009 17:36:31 -0400 Phil Longstaff <plongst...@rogers.com> wrote: > Hi Klaus, > > thanks for reporting these. > > > > > Can't parse the URL postgres://localhost:dbname:user:. > > Is the password blank (in otherwords, you enter a host="localhost", > db="dbname" and user="user" but leave the password field empty)? > Hi Phil, I tried both, with password field empty (postgres configured to 'trust' all users on the local machine => not passowrd required) and with password field filled (postgres configured to require a password (md5 encrypted)). In both cases the above error comes up. Cheers, Klaus _______________________________________________ gnucash-user mailing list gnucash-u...@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-user mailing list gnucash-u...@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
