Simon Riggs wrote:
> I very much like the idea of adding new/custom options to tables. There
> are many uses for that.
Hmm, like what? I'm not sure how would it work for tables; you'd have
to add the options during _PG_init or something like that, and I haven't
tried it. It's mainly for user-defined AMs that this was done.
> What you have here looks fairly hard to program for normal users. I
> don't want to reject the feature, but the proposal you have here isn't
> the best it could be...
Agreed ...
> Can we have something like customer variable classes, but just for
> reloptions?
>
> e.g. WITH (mymodule.my_option_name = X)
> e.g. WITH (funky_trigger.coolness = 25)
>
> We can then create new custom reloptions in roughly the same way we can
> create custom variable classes, or ignore them if module not loaded.
I'm now playing with adding "namespaces" to the options, but that's for
handling options for toast tables. I'm not really sure how would it
work for regular options.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.