Regarding libpq:
I have a table defined as follows to log instances of a service.

CREATE TABLE service_instance(
service_instance_id serial PRIMARY KEY,
started timestamp,
finished timestamp,
indial text,
pin_in text,
FOREIGN KEY(indial, pin_in) REFERENCES service(indial, pin_in)
);

I would like to insert a row into the table to log the current service
instance. I believe I simply leave out the serial primary key from the
insert statement to get the next default value. However, directly after the
insert I need to know the default value used for this field.
Is this possible with the libpq interface. Can I somehow use object
PQoidValue(res) to find the serial id of the inserted row, or is there
another way?

calsa