Issue 44000 - deleting a record from a PostgreSQL table with a SERIAL field leaves garbage
Summary: deleting a record from a PostgreSQL table with a SERIAL field leaves garbage
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m80
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-03-03 14:58 UTC by Frank Schönheit
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
SQL script to generate the sample table(s) in a PostgreSQL database (390 bytes, application/sql-script)
2005-03-03 15:03 UTC, Frank Schönheit 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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 7.03.02.00, 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?

Thanks,
Mike Olson
University of Wisconsin-Madison
German Department