https://bugs.freedesktop.org/show_bug.cgi?id=66662
Priority: medium
Bug ID: 66662
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Other: Autofield is not working for postgresql
Severity: normal
Classification: Unclassified
OS: All
Reporter: ali.jou...@gmail.com
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.3.3 release
Component: Database
Product: LibreOffice
Steps to reproduce:
if I create a table in postgresql, containing a field with a serial type as
primary key,
and then I used Libreoffice Base with SDBC (postgresql) driver to edit the
table
Current behavior:
first the ID field doesn't show "autofield" like it used to in previous
versions,
second if I started to enter data and then I moved to another row or blur\lose
focus from the current row, the ID becomes 0
also all the fields with default value (set from the table definition not from
LO base) gets weird values when the row lose focus
e.g if the default value is "now()" instead of getting "2013-07-07" I get
"now()" after the row lose focus
the only way to get the real ID and the correct default values is to hit the
refresh button
the real issue is you can't save before you hit refresh (the ID is still 0) and
sometimes you lose all the rows data when you press refresh
Expected behavior:
in previous versions when I open the table the word "autofield" is written on
the ID field, and when the current row lose focus\or press "save" the actual ID
shows
and also the default values reflected automatically when the row lose focus
if it was "now()" when i lose focus the data field becomes "2013-07-07" same
for custom functions
sidenote: before version 4.0.2.2 the ID field used to work fine but the default
values had the same behavior of versions after 4.0.2.2
Operating System: All
Version: 4.0.3.3 release
--
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
