You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@datasketches.apache.org by "rafalxs (via GitHub)" <gi...@apache.org> on 2023/02/02 20:02:42 UTC
[GitHub] [datasketches-postgresql] rafalxs opened a new issue, #59: extension upgrade path
rafalxs opened a new issue, #59:
URL: https://github.com/apache/datasketches-postgresql/issues/59
Hi,
In my database I have data sketches in version 1.3.0 and I would like to upgrade to 1.5.0.
Using standard upgrade path fails:
```
ds_upgrade_test=# alter extension datasketches update;
ERROR: extension "datasketches" has no update path from version "1.3.0" to version "1.5.0"
```
Is there a way to create / build extension upgrade script (`datasketches--1.3.0--1.5.0.sql` ?) that would support such an update?
I cannot go with
```
drop extension datasketches;
create extension datasketches;
```
as large number of table's columns depend on `hll_sketch` type.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For additional commands, e-mail: commits-help@datasketches.apache.org
[GitHub] [datasketches-postgresql] jmalkin commented on issue #59: extension upgrade path
Posted by "jmalkin (via GitHub)" <gi...@apache.org>.
jmalkin commented on issue #59:
URL: https://github.com/apache/datasketches-postgresql/issues/59#issuecomment-1548669660
@rafalxs This was also included (and extended to 1.6) in the newest official release. No need to grab an unreleased version branch directly from github!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For additional commands, e-mail: commits-help@datasketches.apache.org
[GitHub] [datasketches-postgresql] AlexanderSaydakov closed issue #59: extension upgrade path
Posted by "AlexanderSaydakov (via GitHub)" <gi...@apache.org>.
AlexanderSaydakov closed issue #59: extension upgrade path
URL: https://github.com/apache/datasketches-postgresql/issues/59
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For additional commands, e-mail: commits-help@datasketches.apache.org
[GitHub] [datasketches-postgresql] jmalkin commented on issue #59: extension upgrade path
Posted by "jmalkin (via GitHub)" <gi...@apache.org>.
jmalkin commented on issue #59:
URL: https://github.com/apache/datasketches-postgresql/issues/59#issuecomment-1416278636
We are trying to look into this, but don't have a target date at this point.
Just curious: Is there any specific new feature you need from 1.5?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For additional commands, e-mail: commits-help@datasketches.apache.org
[GitHub] [datasketches-postgresql] rafalxs commented on issue #59: extension upgrade path
Posted by "rafalxs (via GitHub)" <gi...@apache.org>.
rafalxs commented on issue #59:
URL: https://github.com/apache/datasketches-postgresql/issues/59#issuecomment-1418934327
We don't have any specific requirement at the moment. We'd like:
- be compliant with internal patching policy (1.3 is quite old now)
- keep our options open for future use
Thanks for help and a patch!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For additional commands, e-mail: commits-help@datasketches.apache.org
[GitHub] [datasketches-postgresql] AlexanderSaydakov commented on issue #59: extension upgrade path
Posted by "AlexanderSaydakov (via GitHub)" <gi...@apache.org>.
AlexanderSaydakov commented on issue #59:
URL: https://github.com/apache/datasketches-postgresql/issues/59#issuecomment-1414541272
I am not quite sure how to do this. We did not have resources so far to figure out all details.
Do you care about the hll_sketch only? If so, I don't think there are any SQL changes for that sketch. So making and installing a new .so should be sufficient. But I am not sure how to tell the database to reload the .so. And it will still think it is running 1.3.0
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For additional commands, e-mail: commits-help@datasketches.apache.org