[Kexi] Postgresql and Kexi 2.2 import database working?

[Adam Pigg]

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