To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63918 Issue #:|63918 Summary:|In a PostgreSQL table, a column of custom-domain type |is unreadable in Base through the SDBC driver. Component:|Database access Version:|OOo 2.0.2 Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|jbu Reported by:|pierdeux
------- Additional comments from [EMAIL PROTECTED] Sun Apr 2 18:15:06 -0800 2006 ------- Versions: PostgreSQL 8.1.3, OOo 2.0.2 (WinXP), SDBC-postgresql driver 0.7.0. The columns of type "user-defined domain" in PostgreSQL (backend) are empty and uneditable when viewed in OOoBase (frontend), using the SDBC driver. Reproducing the problem: ------------------------ 1) The backend setup in PostgreSQL. Create a new database and execute the following SQL instructions: ******************************************* -- create two domains and a table, and populate the table. CREATE DOMAIN one_digit AS int2 NOT NULL CONSTRAINT one_digit_check CHECK ((VALUE >= 0) AND (VALUE <= 9)); CREATE DOMAIN a_vowel AS bpchar(1) CONSTRAINT a_vowel_check CHECK ((VALUE = 'a') OR (VALUE = 'e') OR (VALUE = 'i') OR (VALUE = 'o') OR (VALUE = 'u') OR (VALUE = 'y')); CREATE TABLE test ( id serial, an_integer int2, a_digit one_digit, a_letter char(1), a_vowel a_vowel, CONSTRAINT test_pkey PRIMARY KEY (id) ) WITHOUT OIDS; INSERT INTO test (an_integer,a_digit,a_letter,a_vowel) VALUES (1,1,'a','a'); INSERT INTO test (an_integer,a_digit,a_letter,a_vowel) VALUES (2,2,'e','e'); INSERT INTO test (an_integer,a_digit,a_letter,a_vowel) VALUES (3,3,'i','i'); INSERT INTO test (an_integer,a_digit,a_letter,a_vowel) VALUES (4,4,'o','o'); INSERT INTO test (an_integer,a_digit,a_letter,a_vowel) VALUES (5,5,'u','u'); INSERT INTO test (an_integer,a_digit,a_letter,a_vowel) VALUES (6,6,'y','y'); *********************************************** 2) The frontend setup in OOoBase. Open OOoBase, "connect to an existing database", using the postgresql driver, dbname=postgres host=localhost port=5432. Login, password. Save the database. In OOoBase, visualize the table "test". The columns "id", "an_integer" and "a_letter" contain the expected values and are editable. Whereas the columns "a_digit" and "a_vowel" are empty and uneditable. Similar results when using queries, such as this one: SELECT an_integer FROM test; In that case, the result is a one-column table with 6 empty rows. --------------------------------------------------------------------- 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]
