Re: [GENERAL] Schema search_path and views

2006-11-06 Thread Just Someone
Cool! That explains it fully. So i guess there will be a better performance to the pre-generated views at the price of more views. Thanks! On 11/6/06, Merlin Moncure <[EMAIL PROTECTED]> wrote: On 11/6/06, Just Someone <[EMAIL PROTECTED]> wrote: > I have a database with multiple schemas all wit

Re: [GENERAL] Schema search_path and views

2006-11-06 Thread Merlin Moncure
On 11/6/06, Just Someone <[EMAIL PROTECTED]> 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 tr

Re: [GENERAL] Schema search_path and views

2006-11-06 Thread William Leite Araújo
2006/11/6, Just Someone <[EMAIL PROTECTED]>: 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, andwhen executed will be executed against the current schema. Whenever I try it, it seem

[GENERAL] Schema search_path and views

2006-11-06 Thread Just Someone
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 schem