Thread: truncate multiple tables doesnt work
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.
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
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
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
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
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
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