Artur Muszyński

Results 6 comments of Artur Muszyński

After inserting each row SELECT...WHERE id=nextval() is called. I believe it should be replaced with should be curval().

Problem occurs also in version 10.0.6005 :-( ![Przechwytywanie](https://user-images.githubusercontent.com/8614317/84517389-8bb00d80-accf-11ea-819f-567883cf8e45.PNG)

Sorry, my mistake, function name is **currval**. According to documentation: `nextval(regclass) | bigint | Advance sequence and return new value` `currval(regclass) | bigint | Return value most recently obtained with...

Hello again. I tried to install Delphi IDE and pull source code from git to do some debugging but this is too much for me. Borland's Turbo Pascal on MSDOS...

Note that SERIAL is not real type. Heidi tries to detect "autoincrement" column in MySQL flavor, PG is not very well supported. This is the reason.

Updating sequence using MAX() probably will work but this is not right solution. Real sequence values should be dumped and restored separately as pg_dump does.