Simon Riggs wrote: > Custom variable classes are often useful, but they are system wide. It > would be good to be able to use table-level options and have them work > very similarly to something we already have. Table-level options are > just an obvious "normalisation" of how we handle parameters. > > If you really can't see a use for this, OK, then: Please can you put in > a plugin API for user defined reloptions as well as what you are > proposing. We discussed this before in late July/early Aug on thread > "Uncopied parameters..."
I've been giving this a thought and I don't see any easy way to handle it. Since I've been threatened that this whole thing may be punted for 8.5 if I'm not quick about it, I've left this alone for now, and will concentrate on getting the namespace thing done which will allow specifying reloptions for the toast table by an ALTER TABLE on the main table. It's not that I don't see a use for it; it's just that I don't have the time for it right now. (Note: I think there are ways to do this; they'll involve storing the unknown options as a text array. It won't be pretty or performant, but it seems the only way around the fact that heap_reloptions comes hardcoded with the system.) -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
