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]

Reply via email to