Issue 23530 - No data Retrival for WITHOUT OID Tables in PostgreSQL
Summary: No data Retrival for WITHOUT OID Tables in PostgreSQL
Status: CLOSED DUPLICATE of issue 10229
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-12-13 16:27 UTC by aspireme420
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

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

Attachments
Error ScreenShot (53.02 KB, image/png)
2003-12-13 16:30 UTC, aspireme420 		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 aspireme420 2003-12-13 16:27:43 UTC 
This incompatibility is with
1. StarOffice 7.0
2. OpenOffice 1.1
and the incompatibility is when I retrieve data into Star SpreadSheet or  Open
Office SpreadSheet
I am greeted with an error field OID  not found.
Though these both are connecting to PostgreSQL  7.3.4 (Linux GCC 3.x) via
psqlODBC  07.02.0003
On the Same time WinSQL connects as usual via psqlODBC  07.02.0003  and is
working fine with WITHOUT OIDS tables.

Our Test config was:
--------------------------
Client :-
O.S           Win XP (No service pack)
OpenOffice    1.1  Windows version
StarOffice      7.0   Eval Pack
psqlODBC 07.02.0003
Server  :-
OS                      RH 9.0 kernel-2.4.20-24.9
PostgreSQL       7.3.4

You may recreate the database as :

create table checkoo(id bigserial , name varchar (20) , details varchar (200))
WITHOUT OIDS;
insert some data :
insert into checkoo (name,details) values ('OO Not','Works without OIDS');

Now connect and OO will say Attributte OID not FOUND
Comment 1 aspireme420 2003-12-13 16:30:05 UTC 
Created attachment 11928 [details]
Error ScreenShot
Comment 2 marc.neumann 2003-12-15 10:18:46 UTC 
Hi,

I can reproduce this.
Send to the right developer, confirm and set target.

Bye Marc
Comment 3 marc.neumann 2003-12-15 11:51:08 UTC 
set target
Comment 4 aspireme420 2003-12-15 15:30:29 UTC 
Hello ,
How far is OOo 2.0 ?
To add more
1. I have sucessfully recreated this problem in Win2000
2.  And more Office XP Excel also throws the same error (This must not be
mentioned here but just for information sake for developers)
Comment 5 ocke.janssen 2003-12-16 08:21:19 UTC 
Hi ,

I found a mail in the dev mailing lsit about this problem. May be this helps you.
http://dba.openoffice.org/servlets/ReadMsg?list=dev&msgId=496310

Best regards,

Ocke

*** This issue has been marked as a duplicate of 10229 ***
Comment 6 hans_werner67 2004-02-02 12:25:51 UTC 
change subcomponent to 'none'
Comment 7 ocke.janssen 2004-02-10 14:37:35 UTC 
close it