[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Trouble converting database



On Sat, Jun 9, 2012 at 10:03 AM, Robert James Clay <..hidden..> wrote:
> On Sat, 2012-06-09 at 12:28 -0400, Robert James Clay wrote:
>> On Fri, 2012-06-08 at 21:36 -0400, Chris Travers wrote:
>> > I would comment out the check constraint on line 483 of the
>> > Pg-Database.sql and try again.
>> >
>> > Then I would look at the data in the entity table and see what might
>> > be throwing it.
>>
>>     Decided to go ahead & try that but didn't get as far as checking the
>> entity table.  I tried commenting out that one constraint (just inserted
>> ",--" the "check" part of the line) & tried the conversion again but now
>> come up with a different error:
>>
>> ERROR:  new row for relation "person" violates check constraint
>> "person_last_name_check"
>>
>>    Looking at that;  it's both an alphanumeric and NOT NULL
>> constraint...
>
>   But looking further, this time in the apache error log;  it comes
> with this issue with an insert into the person table:
>
> ERROR:  null value in column "first_name" violates not-null constraint

Check your employee table in 1.2

Best Wishes,
Chris Travers

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users