Thread: truncate multiple tables doesnt work

truncate multiple tables doesnt work

From
Andrew Chen
Date:
I have pgadmin3 1.14.1 and postgresql 9.1, when I select multiple tables, right click and select truncate, it
truncatesonly one table at a time.  

Re: truncate multiple tables doesnt work

From
Guillaume Lelarge
Date:
On Wed, 2012-02-15 at 12:01 -0800, Andrew Chen wrote:
> I have pgadmin3 1.14.1 and postgresql 9.1, when I select multiple tables,
> right click and select truncate, it truncates only one table at a time.

You cannot select more than one object in the browser.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



Re: truncate multiple tables doesnt work

From
Dave Page
Date:
On Wed, Feb 15, 2012 at 8:29 PM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
> On Wed, 2012-02-15 at 12:01 -0800, Andrew Chen wrote:
>> I have pgadmin3 1.14.1 and postgresql 9.1, when I select multiple tables,
>> right click and select truncate, it truncates only one table at a time.
>
> You cannot select more than one object in the browser.

You can in the list view.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Re: truncate multiple tables doesnt work

From
Guillaume Lelarge
Date:
On Wed, 2012-02-15 at 20:31 +0000, Dave Page wrote:
> On Wed, Feb 15, 2012 at 8:29 PM, Guillaume Lelarge
> <guillaume@lelarge.info> wrote:
> > On Wed, 2012-02-15 at 12:01 -0800, Andrew Chen wrote:
> >> I have pgadmin3 1.14.1 and postgresql 9.1, when I select multiple tables,
> >> right click and select truncate, it truncates only one table at a time.
> >
> > You cannot select more than one object in the browser.
> 
> You can in the list view.
> 

Oh crap. I didn't know that. Shouldn't we disallow the contextual menu
there?


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



Re: truncate multiple tables doesnt work

From
Dave Page
Date:
On Wed, Feb 15, 2012 at 8:34 PM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
> On Wed, 2012-02-15 at 20:31 +0000, Dave Page wrote:
>> On Wed, Feb 15, 2012 at 8:29 PM, Guillaume Lelarge
>> <guillaume@lelarge.info> wrote:
>> > On Wed, 2012-02-15 at 12:01 -0800, Andrew Chen wrote:
>> >> I have pgadmin3 1.14.1 and postgresql 9.1, when I select multiple tables,
>> >> right click and select truncate, it truncates only one table at a time.
>> >
>> > You cannot select more than one object in the browser.
>>
>> You can in the list view.
>>
>
> Oh crap. I didn't know that. Shouldn't we disallow the contextual menu
> there?

No - the whole point is to allow operations on multiple objects at
once. Iirc, things like Drop Object work fine with multiple objects.



-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Re: truncate multiple tables doesnt work

From
Guillaume Lelarge
Date:
On Wed, 2012-02-15 at 20:34 +0000, Dave Page wrote:
> On Wed, Feb 15, 2012 at 8:34 PM, Guillaume Lelarge
> <guillaume@lelarge.info> wrote:
> > On Wed, 2012-02-15 at 20:31 +0000, Dave Page wrote:
> >> On Wed, Feb 15, 2012 at 8:29 PM, Guillaume Lelarge
> >> <guillaume@lelarge.info> wrote:
> >> > On Wed, 2012-02-15 at 12:01 -0800, Andrew Chen wrote:
> >> >> I have pgadmin3 1.14.1 and postgresql 9.1, when I select multiple tables,
> >> >> right click and select truncate, it truncates only one table at a time.
> >> >
> >> > You cannot select more than one object in the browser.
> >>
> >> You can in the list view.
> >>
> >
> > Oh crap. I didn't know that. Shouldn't we disallow the contextual menu
> > there?
> 
> No - the whole point is to allow operations on multiple objects at
> once. Iirc, things like Drop Object work fine with multiple objects.
> 

Yeah, I just tried that, and indeed it works.

Not for truncate, though... which I guess should be treated as a bug.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



Re: truncate multiple tables doesnt work

From
Guillaume Lelarge
Date:
On Wed, 2012-02-15 at 21:37 +0100, Guillaume Lelarge wrote:
> On Wed, 2012-02-15 at 20:34 +0000, Dave Page wrote:
> > On Wed, Feb 15, 2012 at 8:34 PM, Guillaume Lelarge
> > <guillaume@lelarge.info> wrote:
> > > On Wed, 2012-02-15 at 20:31 +0000, Dave Page wrote:
> > >> On Wed, Feb 15, 2012 at 8:29 PM, Guillaume Lelarge
> > >> <guillaume@lelarge.info> wrote:
> > >> > On Wed, 2012-02-15 at 12:01 -0800, Andrew Chen wrote:
> > >> >> I have pgadmin3 1.14.1 and postgresql 9.1, when I select multiple tables,
> > >> >> right click and select truncate, it truncates only one table at a time.
> > >> >
> > >> > You cannot select more than one object in the browser.
> > >>
> > >> You can in the list view.
> > >>
> > >
> > > Oh crap. I didn't know that. Shouldn't we disallow the contextual menu
> > > there?
> > 
> > No - the whole point is to allow operations on multiple objects at
> > once. Iirc, things like Drop Object work fine with multiple objects.
> > 
> 
> Yeah, I just tried that, and indeed it works.
> 
> Not for truncate, though... which I guess should be treated as a bug.
> 

I added a ticket to work on this at a later time.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com