neondatabase / neon

Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, code-like database branching, and scale to zero.
https://neon.tech
Apache License 2.0
14.52k stars 422 forks source link

pg_anon setup code fail and does not properly retry #7372

Open skyzh opened 5 months ago

skyzh commented 5 months ago

The check for setting up extension is to check if anon is installed. However, if the post-installation fails, anon has been installed anyways, and we do not retry the post-installation code.

skyzh commented 5 months ago

also need to allow users to drop the extensions by themselves, i.e., when the feature flag gets disabled?

skyzh commented 5 months ago

so i feel the good way to set this up is to hook create/drop extension... maybe?

skyzh commented 4 months ago

yet another problem observed by Matthias: we create the test data table for everyone who enables the extension