[Kexi] Postgresql and Kexi 2.2 import database working?

[Adam Pigg]

I should also mention that the previous  fix breaks compatibility with 7.x and 
8.0 databases....all of which are end of life anyway.  So you need to use 
atleast 8.1

Adam

On Saturday 04 September 2010 11:22:58 Noli Sicad wrote:
> 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'...').