To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=75290
Issue #|75290
Summary|Access to postgresql database is readonly -- no edit a
|llowed
Component|Database access
Version|OOo 2.0.2
Platform|All
URL|
OS/Version|Linux
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|gjrussell2
------- Additional comments from [EMAIL PROTECTED] Sun Mar 11 22:28:40 +0000
2007 -------
When I access postgresql database (using either jdbc or odbc) the access is
readonly --- I can't edit or delete rows. The "Edit Data" button is
disabled. Details follow:
Cheers,
Geoff Russell
Ubunto 6.06.1, postgresql 8.1
The following error is in the postgres log.
------------------------------------------------------------ Start error
CONN ERROR: func=PGAPI_GetInfo30, desc='', errnum=209, errmsg='Unrecognized key
passed to SQLGetInfo30.'
------------------------------------------------------------ End error
And also:
STATEMENT ERROR: func=PGAPI_SetStmtAttr, desc='', errnum=28, errmsg='Unsupported
statement option (Set)'
------------------------------------------------------------
hdbc=138465536, stmt=139330016, result=0
manual_result=1, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=-2, statement='(NULL)'
stmt_with_params='(NULL)'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=3,
scroll_concurrency=1
cursor_name=''
----------------QResult Info -------------------------------
CONN ERROR: func=PGAPI_SetStmtAttr, desc='', errnum=0, errmsg='(NULL)'
------------------------------ odbc.ini
[testdb]
Description = testdb
Driver = PostgreSQL
Trace = Yes
TraceFile = /tmp/psqlodbc.log
Database = testdb
Servername = localhost
UserName = geoff
Password =
Port = 5432
Protocol = 6.4
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
-------------------------------- odbcinst.ini
[PostgreSQL]
Description = PostgreSQL ODBC driver
Driver = /usr/lib/odbc/psqlodbc.so
Setup = /usr/lib/odbc/libodbcpsqlS.so
Debug = 0
CommLog = 1
---------------------------------------------------------------------
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]
