Re: [pgadmin-hackers] RFE: Add a TRUNCATE script to scripts menu

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: [pgadmin-hackers] RFE: Add a TRUNCATE script to scripts menu
Дата
Msg-id 4746F3EE.9030301@postgresql.org
обсуждение исходный текст
Ответ на Re: RFE: Add a TRUNCATE script to scripts menu  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-support
Guillaume Lelarge wrote:
> Hi Andrew,
>
> Andrew Lazarus a écrit :
>> Wednesday, October 3, 2007, 1:12:52 AM, you wrote:
>>
>> GL> andrew@pillette.com a écrit :
>>>> to go with INSERT, DELETE, etc.
>> GL> I don't see much interest in a TRUNCATE script because there's nothing
>> GL> more to add on the script. How about a simple "Truncate" or "Empty
>> GL> Table" menu in the contextual menu ?
>>
>> Works for me! (Maybe even two: TRUNCATE and TRUNCATE ... CASCADE)
>>
>
> Here is the patch that adds a TRUNCATE and a TRUNCATE CASCADE menus.
> They won't be in the 1.8 release but I hope it will be applied for the
> next one.

Thanks Guillaume - I've applied this with the following tweaks:

- Update the row count and refresh the properties list following the
truncate.

- Add a stronger warning to the 'Are you sure you want to continue'
dialogue.

Thanks, Dave

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

Предыдущее
От: Enrique Pozo González
Дата:
Сообщение: Problemas...
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Column names in view