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 sequence nextval increased by (1 + number of rows) instead of 1

eramart's profile image eramart posted 1 month ago in General Permalink

When adding a row using table grid (Insert row), sequence nextval is increased by (1 + number of rows) instead of 1. Seen from HeidiSQL 10 onward (in HeidiSQL 9.5 value increased by 1). Possibly looped nextval call after adding row (checking/drawing, etc)?

ansgar's profile image ansgar posted 1 month ago Permalink

HeidiSQL does not fire nextval() anywhere, I am even unsure if that's an API method or SQL code. I guess that has more to do with the detection of default values of an auto-incremented integer column. The table designer displays that in a broken way currently.

eramart's profile image eramart posted 4 weeks ago Permalink

I believe that the issue #279 is about this behaviour

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




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.