To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=3872
------- Additional comments from [EMAIL PROTECTED] Thu Mar 3 06:43:40 -0800 2005 ------- created via Tools|SQL in OOo :). Executed the following: CREATE TABLE customer ( customer_id SERIAL, name CHAR(30) ) Declaring customer_id as PRIMARY KEY (either directly in the statement, or later on via OOo's table design) didn't change anything - it worked with and without the PK. Of course the above means that psql implicitly used oids with the table. If I add an WITHOUT OIDS to the CREATE statements, then OOo fails to even *open the table. The error message then is ERROR: column "oid" does not exist. Well, that's right, but funnily this happens when we try to execute the statement SELECT * from "public"."customer" I looked into the ODBC trace - we do *nowhere* refer to an oid column, nevertheless the SELECT fails. Though, it still seems to be an OOo problem: If I use ODBCTest with the above SELECT statement, this works like a charm. Hmm. /me is confused. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
