Unable to insert into a table which has a field SQLPP_PRIMARY_KEY about sqlpp11 HOT 8 CLOSED

Hi,

Does removing the ::sqlpp::tag::must_not_insert property solve the problem?

And yes, ::sqlpp::tag::must_not_insert property should be used for AUTO_INCREMENT columns. Sorry.

from sqlpp11.

And yes, ::sqlpp::tag::must_not_insert should be used for AUTO_INCREMENT columns.

Hmm...

#define SQLPP_DECLARE_COLUMN_GEN_TRAITS_PROC_SQLPP_AUTO_INCREMENT(...) \
   ::sqlpp::tag::must_not_update

Should be ::sqlpp::tag::must_not_insert, ::sqlpp::tag::must_not_update here?
I am not a specialist in databases.

from sqlpp11.

Hello!

Should be ::sqlpp::tag::must_not_insert, ::sqlpp::tag::must_not_update here?

I suppose it should

I am not a specialist in databases.

Me too :)

from sqlpp11.

Postgres allows insert into a field with auto increment declaration, but theoretically others dbms could prohibit it

from sqlpp11.

In the end, it is a design decision. If ids have auto increment, do you want your application to mess with that? I haven't had such a case yet. I therefore disallow both insert and update for auto incremented columns.

from sqlpp11.

Hi Roland!

Ok, so be it.

from sqlpp11.

#73

from sqlpp11.

Done on develop

from sqlpp11.