[Kexi] Postgresql and Kexi 2.2 import database working?

[Adam Pigg]

Ive just tried by importing a reasonably large database from a postgres server 
into a new database on the same server.

It worked a charm...there whas a long delay after pressing the last 'next' 
button while it copied all the data, but it ultimately finished ok.

Let us know if you ahve further problems.

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