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

Re: column STATISTICS lost

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Erwin Brandstetter <brandstetter(at)falter(dot)at>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: column STATISTICS lost
Date: 2010-04-03 03:01:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-hackers
Le 27/03/2010 02:51, Guillaume Lelarge a écrit :
> Le 27/03/2010 01:07, Erwin Brandstetter a écrit :
>> On 26.03.2010 20:47, guillaume(at)lelarge(dot)info wrote:
>>> Le 26/03/2010 17:10, Erwin Brandstetter a écrit :
>>>> [...]
>>>> Column statistcs are lost in the re-engineered SQL in the SQL pane in
>>>> pgAdmin 1.10.2.
>>>> I have just filed ticket #160 in trac describing the problem.
>>> Not sure this really is a bug. We don't put in the SQL pane of the table
>>> all changes about the columns. People can still get that part by
>>> clicking on the column node.
>> My understanding up until now was, that the displayed SQL can be used to
>> recreate an identical table. But maybe that's where I am going wrong?
> I tried a few things and it seems you're right. For example, comments on
> columns are available both in the Column SQL pane and in the Table SQL pane.

OK, I have a patch (attached) that seems to work. It adds some
functions, and I'm not sure I should push this into the 1.10 branch.
What do you guys think about this? only in trunk or in trunk and in the
1.10 branch?


Attachment: ticket160_v1.patch
Description: text/x-patch (4.2 KB)

In response to


pgadmin-hackers by date

Next:From: Dave PageDate: 2010-04-03 09:19:18
Subject: Re: column STATISTICS lost
Previous:From: pgAdmin TracDate: 2010-04-02 20:32:25
Subject: Re: [pgAdmin III] #162: Missing TABLESPACE clause in CREATE DATABASE

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