[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Error when upgrading 1.2 db to 1.3 db
- Subject: Re: Error when upgrading 1.2 db to 1.3 db
- From: Nigel Titley <..hidden..>
- Date: Tue, 10 Jan 2012 18:07:42 +0000
On 10/01/2012 09:08, Chris Travers wrote:
Sorry for the delay. I have been on vacation.
Really no problem, hope you had a good time.
Ahh, OK. I tried adding a heading but it was one of the last in
collation order. After I've sent the table dump to Erik, I'll try this
and see if it fixes things
No doesn't seem to have made any difference. Still the same error
psql:/tmp/ledgersmb/1.2-1.3-upgrade.sql:30: ERROR: null value in column
"heading" violates not-null constraint
CONTEXT: SQL statement "INSERT INTO account (accno, description,
category, gifi_accno, heading, contra, tax) VALUES ( $1 , $2 , $3 ,
$4 , $5 , $6 , $7 )"
PL/pgSQL function "account_save" line 47 at SQL statement
Create a heading with an accno that comes before any of your others in
alphanumeric collation order, and then try again.
Thanks for the pointer