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. > > 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. > > 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
Thanks for the pointer Nigel ------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
