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

Put handle_geometry column after main geometry column #393

Open
wants to merge 1 commit into
base: master
Choose a base branch
from

Conversation

rbovard
Copy link
Contributor

@rbovard rbovard commented Dec 20, 2024

Fix #380

@ponceta
Copy link
Member

ponceta commented Jan 7, 2025

This could only work for new installations and will differ from existing installations.

The only we can handle that in a delta is to copy the column into a new column, drop the actual column, rename the new column with the old name and if necessary alter business logic linked to the old column if necessary. And it will be placed after any eventual.

PUM does not check the column order that's why the upper CI test is green.

https://stackoverflow.com/questions/285733/how-do-i-alter-the-position-of-a-column-in-a-postgresql-database-table

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

Successfully merging this pull request may close these issues.

[ENH] Put the geometry field of the qwat_od.valve table BEFORE all other geometry fields.
2 participants