Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

[PostgreSQL] Inserting row in data editor

arturm's profile image arturm posted 11 months 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 11 months 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.