[PostgreSQL] Inserting row in data editor

arturm's profile image arturm posted 5 years ago in General Permalink

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's profile image ansgar posted 5 years ago Permalink

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.