2.4 postgres database issues

[Phil Longstaff]

My vote is that 2.4.0 goes ahead this week as planned.  This needs to be fixed 
for 2.4.1.

 Phil
---------
I used to be a hypochondriac AND a kleptomaniac. So I took something for it.




________________________________
From: Keith Bellairs <keith at bellairs.org>
To: gnucash-devel <gnucash-devel at gnucash.org>
Sent: Tue, December 21, 2010 10:23:29 AM
Subject: 2.4 postgres database issues

using a new gnucash db created with r19971 in postgres a few  odd things
happen.

1. On reopening the db the following notices appear in the output in the
command prompt window. Are these tables being receated every time?

NOTICE:  CREATE TABLE will create implicit sequence "recurrences_id_seq1"
for serial column "recurrences.id"
NOTICE:  CREATE TABLE will create implicit sequence
"taxtable_entries_id_seq1" for serial column "taxtable_entries.id"
NOTICE:  CREATE TABLE will create implicit sequence "slots_id_seq1" for
serial column "slots.id"
NOTICE:  CREATE TABLE will create implicit sequence "budget_amounts_id_seq1"
for serial column "budget_amounts.id"

These notices appear each time that the existing pg db is opened on starting
gnc.

2. The first action that would update the db such as entry of a new
transaction generates an error message:
Unable to save database
in a popup. If I quit at that point the new transaction is lost. If I do
other stuff it looks like subsequent saves work and the trans is recorded.

3. The lock on the postgres db is never cleared, so that I have to agree to
override the lock each time the db is opened. This was a known bug that may
have regressed.

No time to run debug data out this AM. And maybe these are already know
issues?
_______________________________________________
gnucash-devel mailing list
gnucash-devel at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel