[pgadmin-support] how to view TOAST table

2010-02-04 Thread Abhisekh Mohapatro
Hi I have a table which has a column with datatype BYTEA. In order to trigger TOAST mechanism for the column, I have made the following alteration. ALTER TABLE table_name ALTER COLUMN column_name SET STORAGE EXTERNAL Please suggest me if I have to make any other changes. Also I am unable to vi

[pgadmin-support] Table size

2010-02-04 Thread Benjamin Krajmalnik
In pgAdmin, one can view the total disk size occupied by a table in the statistics view when in the "Tables" context. What query is being used to calculate this? I have found pg_relation_size() but it has to be called for multiple entities in order to arrive at the total utilization. Thanks i

Re: [pgadmin-support] Updating Ubuntu package info

2010-02-04 Thread Guillaume Lelarge
Le 04/02/2010 18:30, Greg Smith a écrit : > Dave Page wrote: >> pgAdmin 1.12 will be released before, or with PostgreSQL 9.0, so there >> won't be a version of Ubuntu shipping with an incompatible PostgreSQL >> and pgAdmin combination. That's how we've done it for the last 10 >> years or so. >>

Re: [pgadmin-support] Feature request: context menu column sorting

2010-02-04 Thread Guillaume Lelarge
Le 04/02/2010 09:39, Dave Page a écrit : > On Wed, Feb 3, 2010 at 11:40 PM, Quan Zongliang > wrote: >> On 2010-2-4 2:56, Guillaume Lelarge wrote: >>> >>> Just got home. This thread is interesting. It's been quite some time >>> that I wanted to create our own wxGrid widget. Something that will all

Re: [pgadmin-support] Updating Ubuntu package info

2010-02-04 Thread Dave Page
On Thu, Feb 4, 2010 at 5:30 PM, Greg Smith wrote: > So it sounds like everybody who has an opinion here would like me to build a > PPA of the current development snapshot on at least some semi-regular > interval.  To follow Ubuntu guidelines, I should use a version number > between the official on

Re: [pgadmin-support] Updating Ubuntu package info

2010-02-04 Thread Greg Smith
Dave Page wrote: pgAdmin 1.12 will be released before, or with PostgreSQL 9.0, so there won't be a version of Ubuntu shipping with an incompatible PostgreSQL and pgAdmin combination. That's how we've done it for the last 10 years or so. I got that part already. My thought was just that were

Re: [pgadmin-support] Updating Ubuntu package info

2010-02-04 Thread Dave Page
On Thu, Feb 4, 2010 at 1:10 PM, Greg Smith wrote: > Yes, but that doesn't make the user very happy--just better informed about > why they're dead in the water.  I'd hate to see the next Long-Term support > version of Debian and Ubuntu, both likely to hang around a while, have > versions of pgAdmi

Re: [pgadmin-support] Updating Ubuntu package info

2010-02-04 Thread Greg Smith
Dave Page wrote: On Thu, Feb 4, 2010 at 9:19 AM, Magnus Hagander wrote: We still produce minor releases to 1.10, no? I certainly don't suggest we back-patch past that, but we do backpatch to the *latest* stable branch. Right - but 1.10 already checks the maximum and minimum supported

Re: [pgadmin-support] Updating Ubuntu package info

2010-02-04 Thread Dave Page
On Thu, Feb 4, 2010 at 9:19 AM, Magnus Hagander wrote: > We still produce minor releases to 1.10, no? I certainly don't suggest > we back-patch past that, but we do backpatch to the *latest* stable > branch. Right - but 1.10 already checks the maximum and minimum supported version numbers and war

Re: [pgadmin-support] Updating Ubuntu package info

2010-02-04 Thread Magnus Hagander
On Thu, Feb 4, 2010 at 10:16, Dave Page wrote: > On Thu, Feb 4, 2010 at 9:07 AM, Magnus Hagander wrote: >> On Thu, Feb 4, 2010 at 09:06, Guillaume Lelarge >> wrote: >>> Le 04/02/2010 04:23, Greg Smith a écrit : Problem #3:  Given the general popularity of Ubuntu and what I'm seeing in

Re: [pgadmin-support] Updating Ubuntu package info

2010-02-04 Thread Dave Page
On Thu, Feb 4, 2010 at 9:07 AM, Magnus Hagander wrote: > On Thu, Feb 4, 2010 at 09:06, Guillaume Lelarge > wrote: >> Le 04/02/2010 04:23, Greg Smith a écrit : >>> Problem #3:  Given the general popularity of Ubuntu and what I'm seeing >>> in the version history here, I think it would also be app

Re: [pgadmin-support] Updating Ubuntu package info

2010-02-04 Thread Magnus Hagander
On Thu, Feb 4, 2010 at 09:06, Guillaume Lelarge wrote: > Le 04/02/2010 04:23, Greg Smith a écrit : >> Problem #3:  Given the general popularity of Ubuntu and what I'm seeing >> in the version history here, I think it would also be appropriate to >> warn that versions of pgAdmin3 before the upcomin

Re: [pgadmin-support] Feature request: context menu column sorting

2010-02-04 Thread Dave Page
On Wed, Feb 3, 2010 at 11:40 PM, Quan Zongliang wrote: > On 2010-2-4 2:56, Guillaume Lelarge wrote: >> >> Just got home. This thread is interesting. It's been quite some time >> that I wanted to create our own wxGrid widget. Something that will allow >> us to sort, filter more easily than the one

Re: [pgadmin-support] Updating Ubuntu package info

2010-02-04 Thread Guillaume Lelarge
Le 04/02/2010 04:23, Greg Smith a écrit : > Problem #1: If you visit http://www.pgadmin.org/download/ , you'll > discover there's no link to any Ubuntu support listed there. > It was removed a few months ago, because no one could handle them anymore. > Problem #2: If you manage to find > http: