search

pgpartman / pg_partman

Partition management extension for PostgreSQL
Other
2.09k stars 281 forks source link

Allow non-superuser installation #512

Open keithf4 opened 1 year ago

keithf4 commented 1 year ago

See about setting superuser = false in pg_partman.control to allow non-superuser installation. With trigger-based partitioning going away, the last function that had SECURITY DEFINER left should be able to have that removed (check_name_length() which was being called by the trigger functions).

soedirgo commented 2 weeks ago

@keithf4 I see that check_epoch_type and check_partition_type are also SECURITY DEFINER - would it cause issues if these were converted into SECURITY INVOKER?