Can an autovalue primary key be created with PostgreSQL?

[cootcraig]

Using LibreOffice: Version 4.0.3.3 (Build ID: 400m0(Build:3))
on Ubuntu Raring.

In LibreOffice base with an external PostgreSQL database through the native driver,
when I set integer primary keys with autovalue, the autovalue was not done when the tables were created.

Is this a known problem?

Would the autovalue be done properly if I use the PostgreSQL JDBC driver?

[cootcraig]

Autovalue integer primary keys do work with PostgreSQL through the JDBC driver, postgresql-9.2-1002.jdbc4.jar

Here is what I did: 1) type is integer(serial). 2) Set autovalue.

The type is created as serial in PostgreSQL.

I’m not sure if this can be done with the native driver, but for now I
will assume that the JDBC PostgreSQL driver is the one to use.

[LibreNut]

I want to expand on the comment by cootcraig so that newbies like me will find it useful.

The auto-value primary key works well. If you are comfortable working with libreoffice and not with the database directly (like me) you can follow these steps:

1. Create the new table in LO without the primary key column
2. Create the primary key column in the database directly ( I use pgAdmin to manage the postgres database - I find it very user friendly)
3. Make sure the data type is ‘serial’.

That’s it. When you reconnect your LO to the database the primary key column is available and when you design a form the auto value works too.
Thanks to all the people who have helped me find this solution.

[iplaw67]

The native driver does not support the automagic creation of the correct DDL :

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