Bug 167530

Summary: Import existing pgsql server fails
Product: [Applications] KEXI Reporter: Morreale jean roc <jrm>
Component: Migration/Import/ExportAssignee: Kexi Bugs <kexi-bugs>
Status: CLOSED WAITINGFORINFO    
Severity: normal CC: adam, inksi, staniek
Priority: NOR    
Version: unspecified   
Target Milestone: ---   
Platform: Mandriva RPMs   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:
Attachments: console output of the import database process

Description Morreale jean roc 2008-07-27 16:12:27 UTC
Version:           1.9.95.9 (using KDE 4.0.98)
Installed from:    Mandriva RPMs
OS:                Linux

I can create a pgsql database from scratch using kexi but cannot use an existing one using the import tools.

I launch kexi and select Open existing project stored in a database server, I set up the connexion details of the local server then follow the different steps in the wizard. I select the type of import as structure only.

The import fails with the following message : Could not import data from data source "jrm@localhost:5432" Details : Unspecified error encountered

pgadminIII can connect itself to the db using the 5432 port, the database contains no data and only one single table with a primary key.
Comment 1 Morreale jean roc 2008-08-15 16:19:34 UTC
Created attachment 26862 [details]
console output of the import database process
Comment 2 Adam Pigg 2014-12-02 09:10:31 UTC
is it possible to get the database schema for the failed import?
Comment 3 Jarosław Staniek 2016-01-23 20:32:03 UTC
Very old report. Not enough data.
All I see is error: DROP DATABASE "jerash". Maybe no permissions.

Closing, if there's more info feel free to reopen.