Re: SPI_ERROR_CONNECT
От | Willem Buitendyk |
---|---|
Тема | Re: SPI_ERROR_CONNECT |
Дата | |
Msg-id | 47B143A9.6010300@pcfish.ca обсуждение исходный текст |
Ответ на | Re: SPI_ERROR_CONNECT (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
Tom Lane wrote: >That's a fairly bad workaround (assuming that the function is a > legitimate candidate to be IMMUTABLE) because it defeats potential > optimizations. > > What I'd suggest you do instead is rethink your apparently widespread > habit of whacking your view definitions around on-the-fly. This would > never have worked at all before PG 8.3 (and as you can see we still have > some bugs left in supporting it in 8.3 :-(). Even when it does work, > there is a whole lot of frantic paddling going on just under the > surface. We may sail serenely on like the swan, but not very speedily Yep, already started reorganizing so that I don't have to hack away at the views so much. So far I've been able to do without the functions that would only work with volatile. cheers, willem
В списке pgsql-general по дате отправления: