Re: idea: global temp tables

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: idea: global temp tables
Дата
Msg-id 49F6EDD3.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: idea: global temp tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: idea: global temp tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote: 
> One thing I just noticed is that the spec does not consider
> GLOBAL/LOCAL to be optional --- per spec you *must* write one or the
> other in front of TEMPORARY.
Agreed.
> So we could adopt the view that omitting this keyword
> implies our current non-spec behavior (which is far too useful to
> give up, spec compliance or no) while writing one or the other
> selects the spec behavior.
+1 (+1)
> However, if we're going to do that then we should start
> throwing warnings for use of the keywords, preferably before the
> release in which they actually start doing something different.
We might actually want to have a major release which rejects the
standard syntax before the release where we implement standard
behavior for it.  (After, of course, a major release which issues the
warning.)  When we get to the point of breaking existing code (which
is inevitable if we move to compliance here), it's better to break in
a clear and predictable way....
Of course, that would mean that implementation would be three releases
away (warn, disable syntax, reenable syntax with standard semantics).
-Kevin


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: idea: global temp tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: idea: global temp tables