Skip site navigation (1) Skip section navigation (2)

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

From: Dave Page <dpage(at)postgresql(dot)org>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: Andrew Lazarus <andrew(at)pillette(dot)com>, pgadmin-support(at)postgresql(dot)org, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: [pgadmin-support] RFE: Add a TRUNCATE script to scripts menu
Date: 2007-11-23 15:38:22
Message-ID: 4746F3EE.9030301@postgresql.org (view raw or flat)
Thread:
Lists: pgadmin-hackerspgadmin-support
Guillaume Lelarge wrote:
> Hi Andrew,
> 
> Andrew Lazarus a écrit :
>> Wednesday, October 3, 2007, 1:12:52 AM, you wrote:
>>
>> GL> andrew(at)pillette(dot)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

In response to

pgadmin-hackers by date

Next:From: svnDate: 2007-11-23 17:03:49
Subject: SVN Commit by dpage: r6827 - in trunk/pgadmin3: . pgadmin/frm pgadmin/include/schema pgadmin/schema
Previous:From: svnDate: 2007-11-23 15:36:22
Subject: SVN Commit by dpage: r6826 - in trunk/pgadmin3: . pgadmin/frm pgadmin/include/schema pgadmin/schema

pgadmin-support by date

Next:From: Joshua D. DrakeDate: 2007-11-23 17:45:05
Subject: Re: pgadmin3 1.8.0 for ubuntu/dapper and
Previous:From: Raphaël EnriciDate: 2007-11-23 09:38:30
Subject: Re: pgadmin3 1.8.0 for ubuntu/dapper and

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group