[Libreoffice-bugs] [Bug 67649] Postgresql SDBC updatable views

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=67649

--- Comment #6 from Lionel Elie Mamane  ---
I've tested that if one hacks PostgreSQL to add a primary key on the view (by
direct inserts in pg_constraint) and the default values (by direct inserts in
pg_attrdef) on the columns of the view, LibreOffice considers the view as an
updatable table and it works correctly.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 67649] Postgresql SDBC updatable views

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=67649

Alex Thurgood  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=13
   ||7442

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 67649] Postgresql SDBC updatable views

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=67649

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

 Blocks||104790


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=104790
[Bug 104790] [META] Database connectivity interfaces (ODBC, JDBC..) and
external databases
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 67649] Postgresql SDBC updatable views

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=67649

Julien Nabet  changed:

   What|Removed |Added

 Status|ASSIGNED|NEW
   Assignee|ali.jou...@gmail.com|libreoffice-b...@lists.free
   ||desktop.org

--- Comment #5 from Julien Nabet  ---
No feedback since years, let's put it to NEW and unassign.

Ali: if you want to get back to it, don't hesitate to assign yourself again.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 67649] Postgresql SDBC updatable views

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=67649

Lionel Elie Mamane lio...@mamane.lu changed:

   What|Removed |Added

 Status|UNCONFIRMED |ASSIGNED
   Assignee|libreoffice-b...@lists.free |ali.jou...@gmail.com
   |desktop.org |
 Ever confirmed|0   |1

--- Comment #1 from Lionel Elie Mamane lio...@mamane.lu ---
(In reply to comment #0)

 while if I used SDBC and Base, all views are read-only,

 it would be great if we can have updatable views in Libreoffice,

 my use case is row-level-security, (...)

Views don't offer row-level security if the users can define their own
server-side (SQL) functions, because the optimiser can decide to call them on
rows outside of the view (if the view condition is more expensive).

Ah, but I now discover that newer PostgreSQL have a security_barrierflag for
that... Oh, nice.

 at least can somebody give me guidance on which file in the source code I
 need to look at so I can try to implementing that my self

Since you intend to work on it yourself, I assign this enhancement to you. I'll
prepare you a few code pointers, but probably not today.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs