search

hankinsoft / SQLPro

SQLPro bug & features tracking.
100 stars 27 forks source link

You don't support identity columns in postgresql #938

Closed willer closed 8 months ago

willer commented 9 months ago

Describe the bug Identity columns are not identified as such anywhere. Not in the Alter Table screen, and not in generated scripts.

To Reproduce Steps to reproduce the behavior: look at a table with identity columns

Expected behavior show the identity columns

Screenshots

Environment details (please complete the following information): SQLPro for Postgresql on Mac

Additional context This is a column type that Postgresql apparently added with version 10.

Issues will be closed until environmental details are provided.

If the above template is not completed, issues with be closed with the statement Issue has been closed. Please edit the initial post (or create a new issue) and follow the template. Once completed, the issue may be reopened.

hankinsoft commented 9 months ago

Reproduced. Investigating this now.

hankinsoft commented 9 months ago

I've got them showing in the database tree and working for the script as.

Screenshot 2023-09-15 at 1 16 44 PM

Just need to figure out the UI for the visual alter/creation. Hopefully will have something last next week or early the week after.

hankinsoft commented 9 months ago

If you get the chance can you try https://sqlprostudio.s3.us-east-1.amazonaws.com/postgres/SQLProPostgres.2023.57.app.zip? That should have improved identity column support.

hankinsoft commented 8 months ago

Marking as closed. If you find any issues, please let me know.