[Kexi] Postgresql and Kexi 2.2 import database working?

Noli Sicad nsicad at gmail.com
Sat Sep 4 03:42:00 CEST 2010


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'...').


More information about the Kexi mailing list