Can an autovalue primary key be created with PostgreSQL? [closed]

asked 2013-06-07 17:00:40 +0100

cootcraig
46 ●2 ●2 ●7

updated 2015-09-07 20:54:08 +0100

Alex Kemp

flag of United Kingdom of Great Britain and Northern Ireland

20859 ●19 ●60 ●59 http://etmg.altervista...

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-21 12:27:30.671266

Comments

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.

cootcraig ( 2013-06-07 17:43:13 +0100 )edit

add a comment

1

answered 2014-02-23 08:11:54 +0100

Libre Nut
26 ●2 ●5 ●3

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:

Create the new table in LO without the primary key column
Create the primary key column in the database directly ( I use pgAdmin to manage the postgres database - I find it very user friendly)
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.