ERD Tools SQL generator doesn't include the sequence object creation

[arguto1993]

ERD Tools SQL generator doesn't include the sequence object creation

[adityatoshniwal]

@arguto1993 What is your pgAdmin version? We had added a logic to reverse engineer serial columns in ERD so that there is no question of sequences.

[arguto1993]

I got the pgAdmin4 from postgres 15.6 installation,
Version 8.2

[adityatoshniwal]

I got the pgAdmin4 from postgres 15.6 installation, Version 8.2

Hi @arguto1993,
Are you using an older .pgerd file? If you generate now with 8.2+ then it will convert sequences to serial if they were originally serial. If it still doesn't work then please share then it means its a manual sequence, which is currently not supported by ERD.

[arguto1993]

I don't think so, my peers gave me the .pgerd, she told me her postgres version is 15 so I assume the pgAdmin4 version is the same as me since I also got postgres 15

[adityatoshniwal]

I don't think so, my peers gave me the .pgerd, she told me her postgres version is 15 so I assume the pgAdmin4 version is the same as me since I also got postgres 15

Please share the pgerd file.

[akshay-joshi]

No response from the author, hence closing it.

[arguto1993]

I can't share the pgerd files, but nevermind, I don't need it anymore for the moment. Thanks