To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=64478 Issue #:|64478 Summary:|oobase crashes on each record insert to a postgres db |through ODBC Component:|Database access Version:|OOo 2.0.1 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|todd_denniston
------- Additional comments from [EMAIL PROTECTED] Tue Apr 18 08:45:21 -0700 2006 ------- On a Fedora Core 4 system with the following versions: postgresql-odbc-08.00.0100-1 unixODBC-2.2.11-3.FC4.1 qt-ODBC-3.3.4-15.4 unixODBC-kde-2.2.11-3.FC4.1 openoffice.org-core-2.0.1.1-5.1 postgresql-8.0.7-1.FC4.1 Begin with a postgres database that has a single table (ptab). The table has three fields, setup as follows: CREATE TABLE ptab ( tadtest_id integer DEFAULT nextval('"ptab_tadtest_id_seq"'::text) NOT NULL, tadtest character varying(50), tadsecitem character varying(15) ); tadtest_id is a SEQUENCEd number. [I will attach a dump and script to load the database, .odbc.ini, and the testingdb.odb I used. Also I will include my firstInsert.txt and secondInsert.txt crash info files] ODBC is setup with a .odbc.ini. Method for problem replication: 1) oobase ~/testingdb.odb> firstInsert.txt 2>&1 2) select Tables 3) double click ptab 4) click in tadtest field 5) type "test" 6) press tab 7) type "test" 8) press enter 9) capture crash info. 10) oobase ~/testingdb.odb> secondInsert.txt 2>&1 11) click "start recovery" 12) select Tables 13) double click ptab 14) click in tadtest field for a new record (i.e. create record 2) 15) do steps 5-9 again --------------------------------------------------------------------- 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]