https://bugs.freedesktop.org/show_bug.cgi?id=45253
Lionel Elie Mamane <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Priority|medium |low CC| |[email protected] Ever Confirmed|0 |1 --- Comment #1 from Lionel Elie Mamane <[email protected]> 2012-02-02 02:50:24 PST --- The whole type handling system of PostgreSQL-SDBC is a mess and needs serious love. Preliminary analysis: most "unknown" types are mapped to "memo". From the described symptoms, the wizard seems to take the first alphabetical in the list of ones mapped to memo and this happens to be "[ _abstime ]" (an array type). My first guess is that the PostgreSQL type "text" is the best match. However, it is mapped to what the LibreOffice UI calls "Text", which I understand is supposed to be SQL VARCHAR and similar. (There is a separate "Text (fix)" for SQL CHAR.) Note: when testing, make sure to close the wizard between tests; when going back and forth between step 1 and 2, the wizard keeps changes you made in step 2, even if you remove and readd a field in step 1. This may make that bug seem like a Heisenbug. Setting low priority as I'm going to focus on data manipulation issues before data definition issues. (data definition can conceivably be done with SQL statements rather than GUI and/or separate PostgreSQL-specific GUI). If this causes an actual data manipulation issue, this will raise the priority. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
