On 11/6/06, Just Someone <just.some@xxxxxxxxx> wrote:
I have a database with multiple schemas all with the same structure (but of course different data...). I want to create a view that will be created in a shared schema, and when executed will be executed against the current schema. Whenever I try it, it seems the view is linked to a specific schema used when creating it, and doesn't reevaluates based on the current schema.
no, or not exactly. views resolve the search path when they are generated. this is a fundemental part of how they work. functions, however, are a bit different. the plans are lazily generated and 'stick' to the tables that are resolved in the search path when the plan is generated, which is basically the first time you run them in a session. so, you could in theory do what you want with a view if it called functions for all the switchable parts. merlin
