[Kexi] Postgresql and Kexi 2.2 import database working?

[Adam Pigg]

That looks like you are importing into a non-kexi database.

Try:
Create a blank database on the server using kexi
Import from your other database into this one.

Adam
On Friday 03 September 2010 13:05:55 Noli Sicad wrote:
> Here's the log. Noli
> ~~~~~~~~~~~~~~~~~
> 
> noli at noli-laptop:~$ kexi
> kexi(6542)/kdecore (services) KMimeTypeFactory::parseMagic: Now
> parsing  "/usr/share/mime/magic"
> kexi(6542)/KexiDB (driver impl) KexiDB::pqxxSqlCursor::drv_open:
> pqxxSqlCursor::drv_open:exception -  "ERROR:  relation "kexi__db" does
> not exist
> LINE 1: SELECT db_value FROM kexi__db WHERE db_property='kexidb_majo...
>                              ^
> "
> kexi(6542)/KexiDB KexiDB::Connection::querySingleString:
> Connection::querySingleRecord(): !executeQuery()  "SELECT db_value
> FROM kexi__db WHERE db_property='kexidb_major_ver' LIMIT 1"
> kexi(6542)/kio (KDirModel) KDirModelPrivate::_k_slotDeleteItems: No
> node found for item that was just removed:
> KUrl("file:///home/noli/Documents/OtagoData")
> kexi(6542)/kio (KDirModel) KDirModelPrivate::_k_slotDeleteItems: No
> node found for item that was just removed:
> KUrl("file:///home/noli/Documents/OtagoData")
> Closing connection while nontransaction still open
> 
> On 9/3/10, Adam Pigg <piggz1 at gmail.com> wrote:
> > Have you any output at the console to aid in this?
> > 
> > Noli Sicad wrote:
> >> Hi,
> >> 
> >> I am moving away from Sqlite3 still there is no support at this
> >> moment. I am migrating to postgresql / PostGIS and trying to import
> >> the data in Kexi2.2
> >> 
> >> 
> >> I am trying to import database from postgresql to Kexi 2.2 now. It is
> >> connecting to the postgresql database but in the last stage of import
> >> the database. It is stuck in "Importing" Form, the last stage next to
> >> Finish.
> >> 
> >> Now, is the Postgresql and Kexi 2,2 import database working?
> >> 
> >> Thanks.
> >> 
> >> Noli
> > 
> > _______________________________________________
> > Kexi mailing list
> > Kexi at kde.org
> > https://mail.kde.org/mailman/listinfo/kexi