> Well, as I see it there’s three broad categories of behavior available: > > 1- Forward nothing non-built-in (current behavior) > 2- Use options to forward only specified non-built-in things (either in > function chunks (extensions, as in this patch) or one-by-one (mark your > desired functions / ops) > 3- Forward everything if a “forward everything” option is set
Then what you are describing here is a parameter able to do a switch among this selection: - nothing, which is to check on built-in stuff - extension list. - all.
"all" seems to be a very blunt instrument but is certainly appropriate in some cases
I see an intermediate setting, giving four categories in total
0. Nothing, as now
1. Extension list option on the Foreign Server
2. Extension list option on the Foreign Data Wrapper, applies to all Foreign Servers of that type
3. All extensions allowed
I would imagine we would need Inclusion and Exclusion on each
e.g. +postgis, -postgis
Cat 2 and 3 would be merged to get the list for the specific server. That would allow you to a default for all servers of +postgis, yet set a specific server as -postgis, for example.
--
Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
