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: 4BB6AF9F.3020905@lelarge.info (view raw or flat)
Thread:
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?


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

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

In response to

Responses

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-2014 The PostgreSQL Global Development Group