Bug 474415 - no rows shown for a particular table using OO Base
Summary: no rows shown for a particular table using OO Base
Keywords:
Status: CLOSED INSUFFICIENT_DATA
Alias: None
Product: Fedora
Classification: Fedora
Component: postgresql-jdbc
Version: 10
Hardware: All
OS: Linux
low
medium
Target Milestone: ---
Assignee: Tom Lane
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2008-12-03 18:41 UTC by Michael J. Chudobiak
Modified: 2013-07-03 03:20 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2009-01-13 18:46:09 UTC
Type: ---
Embargoed:


Attachments (Terms of Use)
database dump of problem table (175.79 KB, text/plain)
2008-12-03 18:41 UTC, Michael J. Chudobiak
no flags Details
full database dump (335.45 KB, text/plain)
2008-12-03 18:46 UTC, Michael J. Chudobiak
no flags Details

Description Michael J. Chudobiak 2008-12-03 18:41:40 UTC
Created attachment 325571 [details]
database dump of problem table

Description of problem: I use Openoffice Base + postgresql-jdbc to edit a particular database. It mostly works, except on one table. If I try to load the table in Base, no rows are shown. If I try to re-create the table (using pgadmin3) and copy the data into the new table, I can briefly access the table. After a few accesses however, the new table becomes inaccessible.

I will attach a database dump for the table in question.

It might work for you a couple of times, but try loading the table in Base repeatedly until it stops loading.


Version-Release number of selected component (if applicable):
postgresql-jdbc-8.3.603-1.1.fc10.i386
openoffice.org-base-3.0.0-9.10.fc10.i386


How reproducible: Always, for me.


Steps to Reproduce: 
1. Use the provided database dump to create the basemodels table.
2. Try accessing this table repeatedly through OO base, using the postgresql-jdbc driver.
  
Actual results: Table becomes inaccessible. No rows are shown.


Expected results: Should show 407 rows.


- Mike

Comment 1 Michael J. Chudobiak 2008-12-03 18:46:09 UTC
Created attachment 325572 [details]
full database dump

This is a full database dump, because the basemodels table has some foreign keys that I forgot about. All tables in the database work fine except for the "basemodels" table.

- Mike

Comment 2 Tom Lane 2008-12-03 21:02:42 UTC
Hm, can you say whether this problem is new in F-10, or was it there before?

Comment 3 Michael J. Chudobiak 2008-12-04 00:53:01 UTC
The problem was also present in F9.

- Mike

Comment 4 Tom Lane 2008-12-04 03:55:34 UTC
OK, I'll try to reproduce on F9.  I won't be able to look at it till next week though --- I'm actually out of town right now and don't have access to my F9 machine.

Comment 5 Michael J. Chudobiak 2009-01-13 16:08:36 UTC
Tom,

Have you had time to look at this sample data? Nudge, nudge...

- Mike

Comment 6 Tom Lane 2009-01-13 17:27:12 UTC
No, not really.  It would save me some time if you explained what "accessing the table through OO base" means, bearing in mind that I know absolutely zero about OO's database features.

Comment 7 Michael J. Chudobiak 2009-01-13 18:46:09 UTC
Argh.

I tried to write an easy-to-follow sequence to reproduce the problem, but I can't reproduce the problem when I create a new OO database file... which leads me to believe that it is strictly an OO problem, rather than postgresql-jdbc.

I still experience the problem in my original OO database file, but recreating that file from scratch has made the problem go away. So there is a real bug somewhere, but I can't document it well enough for developers to fix it...

Closing bug for now.

- Mike


Note You need to log in before you can comment on or make changes to this bug.