[Kexi] Postgresql and Kexi 2.2 import database working?

[Noli Sicad]

I removed the offending data and it is working now.

The Kexi is not Irish friendly :- )

Thanks. Noli

On 9/4/10, Adam Pigg <piggz1 at gmail.com> wrote:
> Surely i havent made a junior mistake like that!  I'll check to see if
> something isnt being escaped, though i swear i thought it was :)
>
> Adam
>
> On Saturday 04 September 2010 02:42:00 Noli Sicad wrote:
>> I think there is problem with reading the data, when the record has this
>> entry,
>>
>> Mr. Bill O'Neilly
>>
>>
>> WARNING:  nonstandard use of \' in a string literal
>> LINE 1: INSERT INTO customer VALUES (14,'Mr  ','Bill','O\''Neill','2...
>>                                                       ^
>> HINT:  Use '' to write quotes in strings, or use the escape string
>> syntax (E'...').
>>
>>
>> Noli
>>
>> `````````````````````````
>>
>> transaction<READ COMMITTED> committed more than once
>> kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal:
>> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof()
>>
>> || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name,
>>
>> o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='barcode' AND
>> o_type=1 LIMIT 1"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "barcode_pkey" for table "barcode"
>> kexi(7247)/KexiDB KexiDB::Connection::querySingleString:
>> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof()
>>  "SELECT o_id FROM kexi__objects WHERE o_type=1 AND
>> lower(o_name)='barcode' LIMIT 1"
>> kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal:
>> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof()
>>
>> || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name,
>>
>> o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='customer'
>> AND o_type=1 LIMIT 1"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "customer_pkey" for table "customer"
>> kexi(7247)/KexiDB KexiDB::Connection::querySingleString:
>> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof()
>>  "SELECT o_id FROM kexi__objects WHERE o_type=1 AND
>> lower(o_name)='customer' LIMIT 1"
>> kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal:
>> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof()
>>
>> || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name,
>>
>> o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='item' AND
>> o_type=1 LIMIT 1"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "item_pkey" for table "item"
>> kexi(7247)/KexiDB KexiDB::Connection::querySingleString:
>> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof()
>>  "SELECT o_id FROM kexi__objects WHERE o_type=1 AND
>> lower(o_name)='item' LIMIT 1"
>> kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal:
>> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof()
>>
>> || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name,
>>
>> o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='orderinfo'
>> AND o_type=1 LIMIT 1"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "orderinfo_pkey" for table "orderinfo"
>> kexi(7247)/KexiDB KexiDB::Connection::querySingleString:
>> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof()
>>  "SELECT o_id FROM kexi__objects WHERE o_type=1 AND
>> lower(o_name)='orderinfo' LIMIT 1"
>> kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal:
>> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof()
>>
>> || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name,
>>
>> o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='orderline'
>> AND o_type=1 LIMIT 1"
>> kexi(7247)/KexiDB KexiDB::Connection::querySingleString:
>> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof()
>>  "SELECT o_id FROM kexi__objects WHERE o_type=1 AND
>> lower(o_name)='orderline' LIMIT 1"
>> kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal:
>> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof()
>>
>> || cursor->storeCurrentRow(data) m_sql= "SELECT o_id, o_type, o_name,
>>
>> o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='stock' AND
>> o_type=1 LIMIT 1"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "stock_pkey" for table "stock"
>> kexi(7247)/KexiDB KexiDB::Connection::querySingleString:
>> Connection::querySingleRecord(): !cursor->moveFirst() || cursor->eof()
>>  "SELECT o_id FROM kexi__objects WHERE o_type=1 AND
>> lower(o_name)='stock' LIMIT 1"
>> transaction<READ COMMITTED> committed more than once
>> WARNING:  nonstandard use of \' in a string literal
>> LINE 1: INSERT INTO customer VALUES (14,'Mr  ','Bill','O\''Neill','2...
>>                                                       ^
>> HINT:  Use '' to write quotes in strings, or use the escape string
>> syntax (E'...').
>