PostgreSQL and serial data type

rant801601 · Post by **rant801601** » Mon 19 Jan 2009 14:42

Is it possible to use serial field and UniDAC will get value on client (DataSet) automatically like it does with MSSQL or I must have sequence in database and define KeySequence like with Oracle database in DataSet ?

rant801601 · Post by **rant801601** » Mon 19 Jan 2009 16:08

I found out I have to modify INSERT SQL (exclude serial field and add RETURNING field) and set Query Options.ReturnParams to True.

Is this proper use or should UniDAC do this automatic ?

Best Regards,
Radovan Antloga

Plash · Post by **Plash** » Tue 20 Jan 2009 10:01

The current version of UniDAC does not support generating INSERT statements with RETURNING automatically.

So you should manually assign such statement to the SQLInsert property, or use the KeySequence property.