Cannot load specific version of an extension
Summary
The version
field of a postgresExtension
appears to be ignored. Given an existing cluster, I want to lead version 1.2
of ltree
:
apiVersion: stackgres.io/v1
kind: SGCluster
metadata:
name: simple
spec:
instances: 1
postgresVersion: 'latest'
pods:
persistentVolume:
size: '5Gi'
postgresExtensions:
- name: ltree
version: '1.2'
Current Behaviour
Version 1.1
is loaded, which is the default stable version, and should be the behavior expected if no version would be specified, but it is specified.
kubectl exec -it simple-0 -c postgres-util -- psql -c "select * from pg_available_extensions()"
name | default_version | comment
--------------------+-----------------+--------------------------------------------------------------
dblink | 1.2 | connect to other PostgreSQL databases from within a database
ltree | 1.1 | data type for hierarchical tree-like structures
plpgsql | 1.0 | PL/pgSQL procedural language
plpython3u | 1.0 | PL/Python3U untrusted procedural language
pg_stat_statements | 1.7 | track execution statistics of all SQL statements executed
Steps to reproduce
Apply the YAML above, or a similar one, and verify with the query above about available exentions.
Expected Behaviour
That ltree
version 1.2
would be loaded, instead of 1.1
.
Environment
- StackGres version:
1.0.0-alpha2