To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=60938 Issue #:|60938 Summary:|postgresql-sdbc: import from calc spreadsheet |produces wrong schema name Component:|Database access Version:|OOo 2.0 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|umehlig
------- Additional comments from [EMAIL PROTECTED] Sat Jan 21 05:21:30 -0800 2006 ------- I tried to import a table from a calc spreadsheet to a postgresql database accessed via the sdbc postgresql driver 0.6.2. I did this by copying a data range from the spreadsheet to the clipboard and pasting it to the "Tables" area of the OOBase window for the PostgreSQL datasource. The Import wizard appears but when trying to save the new table to the database, PostgreSQL complains about a wrong schema name (should be "public", not "xxx"). The database name is "xxx", the user name also "xxx" (true names of database, user and columns substituted by placeholders here and in the error message below). Hope this helps to fix it ... Regards, Ulf PostgreSQL 8.1.2, Linux 2.6.15/i386, OpenOffice 2.0.0-1bpo3 from www.backports.org (for Debian sarge), sdbc postgresql driver 0.6.2 Error code: 1 pq_driver: [PGRES_FATAL_ERROR]ERROR: schema "xxx" does not exist (caused by statement 'CREATE TABLE "xxx"."test" ( "aaaaa" varchar(35), "bbbbb" varchar(35), "ccccc" varchar(35), "ddddd" varchar(10), "eeeee" int2, "fffff" char(1), "ggggg" float8, "hhhhh" varchar(35)) ') --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]