Bug 167530 - Import existing pgsql server fails
Summary: Import existing pgsql server fails
Status: CLOSED WAITINGFORINFO
Alias: None
Product: KEXI
Classification: Applications
Component: Migration/Import/Export (show other bugs)
Version: unspecified
Platform: Mandriva RPMs Linux
: NOR normal
Target Milestone: ---
Assignee: Kexi Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-07-27 16:12 UTC by Morreale jean roc
Modified: 2016-01-23 20:32 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
console output of the import database process (23.58 KB, text/plain)
2008-08-15 16:19 UTC, Morreale jean roc 		Details
View All Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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.