Bug 74168

Summary: Previously working listbox in form shows <Autofield> when adding new records
Product: LibreOffice Reporter: Rajagopal S. Iyer <raju.rajsand>
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED FIXED    
Severity: normal CC: raju.rajsand, robert
Priority: medium    
Version: 4.1.4.2 release   
Hardware: Other   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description Rajagopal S. Iyer 2014-01-29 04:10:25 UTC

    
Comment 1 Rajagopal S. Iyer 2014-01-29 04:14:31 UTC
Thanks for a great product

I was using LO 4.1.0 to design a simple form using postgres 9.3 as backend with native driver.

That for had issues with handling time field.

When I switched over to 4.1.4.2, the time problem was gone but a more serious problem of the list box showing up as <Autofield>.

I tested it in both 32 bit and 64 bit win7
Comment 2 Robert Großkopf 2014-01-29 14:56:09 UTC
Could you attach an example here? I haven't heard about such a behavior before.

Or, if there are data, which you couldn't delete before, you could send the database directly to me, so I will have a look. Maybe the query for the listbox and the connected field don't match together.
Comment 3 Rajagopal S. Iyer 2014-01-31 23:17:08 UTC
After mucking around, I found that it was the underlying PG database tables which were causing the issue.

It so happened that the underlying PG tables were having default values set.

I am still investigating why that happenedin the postgresql area. 

But then it has nothing to do with Libreoffice, I guess.

I am closing this bug as resolved.

If anybody is interested, I will share the details of table structure (of course not data), base .odb files.

Thanks for the responses,

Rajagopal