Issue 44000

Summary: deleting a record from a PostgreSQL table with a SERIAL field leaves garbage
Product: Base Reporter: Frank Schönheit <frank.schoenheit>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: 680m80   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
SQL script to generate the sample table(s) in a PostgreSQL database none

Description Frank Schönheit 2005-03-03 14:58:55 UTC
- pre-requisites (not sure how much the concrete versions do matter):
  - PostgreSQL 8.0.1 running on Windows XP
  - PostgreSQL ODBC, on a different WinXP machine
- use a database document connecting, via ODBC, to the PostgreSQL database server
- import the attached script into the database (you can do so via Tools|SQL in OOo)
- View|Refresh tables to see the newly created table "interprets"
- open the "interprets" table by double-clicking it
- mark the third row
- delete it, confirm the safety question
=> *lot* of assertions
=> all rows are now painted empty, with a red cross in front of it
Comment 1 Frank Schönheit 2005-03-03 15:03:12 UTC
Created attachment 23296 [details]
SQL script to generate the sample table(s) in a PostgreSQL database
Comment 3 ocke.janssen 2005-11-04 09:33:51 UTC
Comment 4 odaata 2008-03-08 02:10:59 UTC
I am also having the same difficulty with deleting rows from tables with a
serial primary key. I can delete from tables with no serial primary key just
fine though. Any workaround for this?

Mike Olson
University of Wisconsin-Madison
German Department