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
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
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.
>>
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
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
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
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
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
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
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
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
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
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
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:
14 matches
Mail list logo