[PostgreSQL] Inserting row in data editor

arturm posted 1 month ago in General

When I am inserting rows into table and click "Post" icon, following sequence appear in log:

INSERT INTO "public"."specialization" ("name") VALUES (E'c');
SELECT "id", "name", "domain" FROM "public"."specialization" WHERE  "id"=nextval('specialization_id_seq'::regclass);

I believe that curval() should be used instead of nextval() in this case.

ansgar posted 1 month ago

Could it be you have an active filter with that "id=nextval(..." ? There is no such code in HeidiSQL.

Please login to leave a reply, or register at first.