] On Fri, Jun 8, 2012 at 11:45 AM, Robert James Clay <[email protected]> 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 <[email protected]> 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): 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. 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
