To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=61881
------- Additional comments from [EMAIL PROTECTED] Wed May 10 01:15:13 -0700
2006 -------
pmike->clu:
1. set up PostgreSQL server from postgresql-8.1-int.msi, on Win2003
2. start pgAdmin, create database "Test", tablespace "pg_default", encoding UTF8
3. create "biblio" table in "Test"
CREATE TABLE biblio
(
"Identifier" varchar(50) NOT NULL,
"Type" varchar(50),
"Address" varchar(50),
"Annote" varchar(50),
"Author" varchar(75),
"Booktitle" varchar(50),
"Chapter" varchar(50),
"Edition" varchar(50),
"Editor" varchar(50),
"Howpublish" varchar(50),
"Institutn" varchar(50),
"Journal" varchar(50),
"Month" varchar(50),
"Note" varchar(50),
"Number" varchar(50),
"Organizat" varchar(50),
"Pages" varchar(50),
"Publisher" varchar(50),
"School" varchar(50),
"Series" varchar(50),
"Title" varchar(75),
"RepType" varchar(50),
"Volume" varchar(50),
"Year" varchar(50),
"URL" varchar(50),
"Custom1" varchar(50),
"Custom2" varchar(50),
"Custom3" varchar(50),
"Custom4" varchar(50),
"Custom5" varchar(50),
"ISBN" varchar(50),
"ID" numeric(16),
"ID_X" int4 DEFAULT nextval(('public."ID_seq"'::text)::regclass),
CONSTRAINT "ID" PRIMARY KEY ("Identifier")
)
WITHOUT OIDS;
ALTER TABLE biblio OWNER TO pgsu;
4. on other computer (WinXP), setup PostgreSQL again, but only ODBC drivers
5. in ODBC manager make a system DSN: PostgreSQL Unicode, settings are on "pg"
screenshots
6. in OO.o (was in m155, now in m167 - no difference) create new "database" (in
OOo terms), settings are on "pg_ooo" screenshots
7. open table "public.biblio" for editing (just duoble-click it), see
"pg_edit_via_ODBC"
8. then I set up SDBC driver, make new "database" in OOo, open "public.biblio"
for edit, see "pg_edit_via_ODBC"
---------------------------------------------------------------------
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]
