Thomas Kellerer <shammat@gmx.net> writes:
> Tom Lane schrieb am 06.02.2021 um 18:09:
>> Yes, that view is supposed to list the versions that are available
>> to be installed.
> So if it is expected to see multiple versions through that view,
> then why do the multiple versions go away when I dump & reload
> the database?
Oh, sorry, -ENOCAFFEINE. I was thinking of
pg_available_extension_versions, which does what I described.
As for pg_available_extensions, that should produce just one row
per extension control file. The only way I can see for it to
produce more is if you have duplicate entries in pg_extension,
which also seems unlikely if not impossible. Maybe you should
provide more detail about exactly what you are seeing, what is
in pg_extension, and what is in your installation's
.../share/extension/ directory.
regards, tom lane