Auto increment postgres serial type in logic app insert row action ID field

Question

Hi,

The insert row action is requiring an ID field but my table in postgres is type serial. Is there anyway to tell the logic app that an ID field does not need to be set on the insert as postgres will auto increment this field?

Answer 1

Hi,

insert row action is requiring an ID

(1) Why?!? Please clarify why you have to use the column ID when you INSERT data and how exactly do you INSERT the data.

(2) If the insert row action is requiring an ID and you have Auto increment then what do you expect to have in the column? Do you want to INSERT your value or use the Auto increment?

Note! Identity in postgres does not behave like identity in SQL Server. You can simply configure: ColumnName INT GENERATED BY DEFAULT AS IDENTITY,

For example:

CREATE TABLE MyTable(
    ID INT GENERATED BY DEFAULT AS IDENTITY,
    Text VARCHAR NOT NULL
);

This way, you get the option to INSERT the value to the column if you want or not. If you do not INSERT the value then the it is Auto increment

Answer 2

Solution

I solved this issue by initalizing an iteger variable that has no vlaue and referncing it in the id colum of the postgers insert Action

Hope this helps ;)