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

Re: Trouble converting database



On Fri, Jun 8, 2012 at 7:09 PM, Robert James Clay <..hidden..> wrote:
> On Fri, 2012-06-08 at 21:36 -0400, Chris Travers wrote:
>> On Fri, Jun 8, 2012 at 11:45 AM, Robert James Clay <..hidden..> wrote:
>> > On Thu, 2012-06-07 at 19:12 -0400, Chris Travers wrote:
>> >> On Thu, Jun 7, 2012 at 12:22 PM, Robert James Clay <..hidden..> wrote:
>> >> > On Thu, 2012-06-07 at 11:03 -0400, Chris Travers wrote:
>> >> >
>> >> >> Try this:
>> >> >>
>> >> >> select * from customer where name !~  '[[:alnum:]_]'::text;
>> >> >>
>> >> >> and the same from vendor.
>> >> >
>> >> >   Both returns zero rows...
>> >>
>> >> And just to be sure, selecting count(*) from these returns a number of
>> >> rows right?
>> >
>> >   Yep;  2 for customers and 23 for vendors, in this particular case.
>>
>> That's strange.
>>
>> If it were me I would try this (on a copy of the data of course):
>
>   That's what I'm already working with...<g>
>
>
>> I would comment out the check constraint on line 483 of the
>> Pg-Database.sql and try again.
>
>   Simply try the conversion again?  The import?  (I.E.; when does that
> sql get used;  any time a database gets created, including during a
> conversion?  Or does it get loaded into Pg and then used from there?)

The conversion operates in a few stages:

1)  Checks 1.2 data
2)  Moves the public schema to lsmb12.  Creates new public schema,
loads with Pg-database etc.
3)  Copies data from lsmb12 into public schema.

The big advantage here is that it's possible to back out from a broken
upgrade and get to exactly where you were after step 1.

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