Re: Views- Advantages and Disadvantages

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Views- Advantages and Disadvantages
Дата
Msg-id 4643D9C2.80601@cox.net
обсуждение исходный текст
Ответ на Re: Views- Advantages and Disadvantages  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Views- Advantages and Disadvantages  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Views- Advantages and Disadvantages  (Jorge Godoy <jgodoy@gmail.com>)
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 05/10/07 21:24, Tom Lane wrote:
> "Leif B. Kristensen" <leif@solumslekt.org> writes:
>> Would it be reasonable to suggest that later versions of PostgreSQL
>> could examine if a function changes data, and quietly marks a function
>> as 'stable' if it doesn't?
>
> My instinctive CS-major reply to that is "only if you've found a
> solution to the halting problem".  However, it's possible that we could
> detect this case for a useful subset of real-world functions ... not
> sure offhand what could be covered.

If there are no INSERT, UPDATE or DELETE statements in the function?

- --
Ron Johnson, Jr.
Jefferson LA  USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGQ9nCS9HxQb37XmcRAuxyAJ9Setk7j5/xg5jwvNi3o6RDceuGLACg1FDS
LptxOrJvoNVSjEATWIeFo+Y=
=5MT8
-----END PGP SIGNATURE-----

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Missing magic block
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)