Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot detect the default value for a generated always as identity column #123

Open
fluca1978 opened this issue Jan 29, 2024 · 3 comments
Open

Comments

@fluca1978
Copy link

When a column is defined as generated always as identity, the COLUMN_DEF returned by the column_info method is empty. This apparently is correct, since pg_get_expr() does not return anything.
However, this could be a problem with other tools, like DBIx::Schema::Loader that are not able to detect that the column is "attached" to a sequence behind the scenes.

@cblake777
Copy link

We're currently running into this issue as well. It's not a problem as it is just a warning, but it is annoying for our systems.

@fluca1978
Copy link
Author

We're currently running into this issue as well. It's not a problem as it is just a warning, but it is annoying for our systems.

It's more than a simple warning, since other tools could not be able to determine the default value with an empty column default value definition.

@cblake777
Copy link

Fair enough, I should rephrase that it's for us it's treating the column as an autoinc and retrieving the value automatically, so the impact for us has been low. It would be much better if we didn't have to deal with it, however.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants