To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96716 Issue #|96716 Summary|writing to a writeable PostgreSQL view does not work Component|Database access Version|OOo 2.4.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|hjakobs
------- Additional comments from [EMAIL PROTECTED] Sat Nov 29 20:59:59 +0000 2008 ------- I clearly understand that writing to views - as opposed to tables - can lead to difficulties and that OOo cannot easily solve these. If a query involving several tables has been created within OOo it's ok that they are not writeable because it is impossible to tell which of the joined table the data should go to. BUT: If a database offers views which are easily writeable because the issue was solved on the database side by including rules on how to deal with the situation, OOo Base should not stop the users from taking advantage from this feature. Views defined in PostgreSQL (or in Oracle, for that matter) show as "tables" in OOo Base, but have a different icon (containing an arrow). Please refrain from taking the information that this is a view as a hint that this "table" is not writeable. The database will complain if it cannot write to it, but it is quite likely that it will work fine if the view has been set up by a knowledgeable person. I connected PostgreSQL via JDBC org.postgresql.Driver to OOo Base. Thank you in advance for understanding the problem. I am sure the person this issue will be addressed to is in the position to find the position in the big heap of code where it says if (table_type == "view") { deny writing } and just delete this little piece of bad code from our beloved OOo. Ust let the database do its job! --------------------------------------------------------------------- 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]