Ads were blocked by your webbrowser.

This is not a 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 3 months 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's profile image ansgar posted 3 months 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.