Re: truncate problem

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: truncate problem
Дата
Msg-id 1045889633.366.13.camel@tokyo
обсуждение исходный текст
Ответ на truncate problem  ("frank_lupo" <frank_lupo@email.it>)
Список pgsql-general
On Thu, 2003-02-20 at 05:20, frank_lupo wrote:
> In 7.2.2 I created a function using the instruction TRUNCATE TABLE inside and it works well.
>
> When I try to call the same function in 7.3.2, I receive the following message:

It was never a good idea to use TRUNCATE inside a function -- you were
living dangerously using it inside one in 7.2. The only change in 7.3
TRUNCATE is no longer allowed.

Note that in current sources (and therefore in 7.4 when it's been
released), Rod Taylor has improved the TRUNCATE implementation to be
transaction-safe, so the restriction has been lifted.

Cheers,

Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: HAVING and column alias
Следующее
От: Greg Stark
Дата:
Сообщение: optimizer bent on full table scan