Bug 167530

Summary:	Import existing pgsql server fails
Product:	[Applications] KEXI	Reporter:	Morreale jean roc <jrm>
Component:	Migration/Import/Export	Assignee:	Kexi Bugs <kexi-bugs>
Status:	CLOSED WAITINGFORINFO
Severity:	normal	CC:	adam, inksi, staniek
Priority:	NOR
Version First Reported In:	unspecified
Target Milestone:	---
Platform:	Mandriva RPMs
OS:	Linux
Latest Commit:		Version Fixed/Implemented 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.