Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | [Postgres] database form list box inserts incorrect primary key value | ||
---|---|---|---|
Product: | Base | Reporter: | prlw1 <prlw1> |
Component: | code | Assignee: | AOO issues mailing list <issues> |
Status: | UNCONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | drewjensen.inbox, helge.kraak, issues, mechtilde |
Version: | OOO310m19 | Keywords: | oooqa |
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
prlw1
2009-07-20 17:51:21 UTC
@prlw1 - Could you tell me what you have for the setting under: Edit>Database>Advanced Settings ( Generated values page ) Generated values, settings, retrieve generated values is off <- is this wrong? Special settings, options, ON: - use outer join syntax - ignore the privileges from the database driver - replace named parameters with ? - use catolg name in select statements - use schema name in select statements - create index with asc or desc statement - form data input checks for required fields OFF: - use sql92 naming constraints - append the table alias name on select statements - display version columns (when available) - end text lines with cr+lf Comparison of Boolean values: default Actually - why would it matter that id is auto_incremented? All the list_box does is read id,shortname, display shortname, and insert id into another table when shortname is selected. @prlw1...hmmm, yes I suppose your right..oops Will get this checked tonight. (btw, the postgres folks released an update to the ODBC driver day before yesterday I think..will try to check with this newer one also) I have the same problem. I've tried to change the odbc driver with the latest (july 20th) but nothing changed. I have also tried to use ODBCng driver from commandprompt inc but it is not in the list of drivers available (in the registry it has a new entry, not the same of others ODBC drivers and the key has no settings). bye Oppssss!!! I forgot to write that I have the same problem with OOo 3.1, windows vista business, postgres 8.4. thx Just checked with the 3.1.1 source code, i.e., OOO310m19, and the behaviour hasn't changed. @ atjensen If you can confirm the problem plase set the issue to NEW @ prlw1 Did you also try the nativ psql connector from http://dba.openoffice.org/drivers/postgresql/index.html#download Just so you know someone is listening - no news yet: - on windows I can only connect to database read-only, so can't insert a new record with the form. - on ubuntu jaunty 9.04, I can't get native connector to install - no errors, just no postgresql in drop down on connect. (Did aptitude install openoffice.org so did have database part of OO installed when installing native connector) - NetBSD side I'll have try to compile connector from source - it would be easier if said source was in the standard tarball... ... so still trying to get a native connector setup to reproduce the bug. Success with the native connector (under windows after reinstalling postgresql - odd as the odbc connection did allow read/write, so hard to say how the permissions on the tables could be wrong) Success also on ubuntu using sudo aptitude install openoffice.org-sdbc-postgresql rather than Tools/Package Manager (With Tools/Package Manager, I could see it insalled in ~.openoffice.org, but postgresql didn't appear listed in oobase) |