Re: column STATISTICS lost

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.

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