Apache OpenOffice (AOO) Bugzilla – Issue 8971
Segmentation fault when saving newly created PostgreSQL table
Last modified: 2006-05-31 14:29:06 UTC
I use OpenWriter 1.0.1 with the data source display. I am connected to a PostgreSQL 7.2.2 database throught unixODBC 2.2.2. I use the 'new sketch of a table' wizard to create a new table. But each time I save it on the end, then OpenOffice crashes with the lonly error message in the console: 'Segmentation fault'. When I reopen OpenWriter, my new table has been created with the right fields.
Sophia, thanks for using and supporting OpenOffice.org. I have a dumb question: what is the "new sketch of a table" wizard?
Sorry, I tried to translate as "new sketch of a table" the french expression "Nouvelle ébauche de table". This entry offers a form which helps to define a new table. This menu entry is accessed in the data sources explorer (tree on the left) by right clicking on the 'Table' node.
ah! :) You used the form auto pilot (translated from the german version :) on a table, didn't you? But you are creating a form document, not a table, am I right? Does the same happen with other data source( type)s? For instance the Bibliography?
a/ No, I didn't used the form auto pilot but the table auto pilot in which I used a form to define the fields of the table. b/ This crash does not append with the 'Bibliography' database. My database is not crashed because I can restart OpenOffice Writer and fully access to my database without restarting it. The last messages that PostgreSQL logged were: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'essai4_pkey' for table 'essai4' DEBUG: pq_recvbuf: unexpected EOF on client connection
Sophia, I admit I am heavily confused - there is no such thing as an auto pilot for a table - at least not to my knowledge, except somebody built such a piece of software specially for the french version (which I doubt) What I (this time :) suppose is that you mean the "normal" table design component, means the component which is used when editing an existent as well as when creating a new one. Yes? (I now strongly suppose so. I looked into the source, and "Nouvelle ébauche de ~table" is the french translation of "New ~Table Design")
Yes, that's right.
Ah! Okay, at least I understand what this is about :). Thanks Sophia! changing the summary from Segmentation fault when saving new table created with the wizard to Segmentation fault when saving newly created PostgreSQL table 'cause the "wizard" in the old summary is somewhat misleading. Sophia, sorry, I have some more questions (: * What table structure do you use when creating the new table? * Does the crash _depend_ on the table structure? Does it happen no matter what field types you use, and/or no matter how may fields you use? Can you please try to strip down this to a table as simple as possible?
The bug still exist if I use the SQL console of OpenOffice (right click on the data source node -> 'SQL...'). I just executed the following SQL instruction: CREATE TABLE a (a INTEGER PRIMARY KEY ); I also got the same result with other types: VARCHAR DATE
Hi Sophia, this bug is fixed now. I didn't test if it is already in the srx643 developer version but it should be in the next release. Best regards, Ocke
*** Issue 9020 has been marked as a duplicate of this issue. ***
closing
change subcomponent to 'none'