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

[pgAdmin III] #160: STATISTICS lost

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #160: STATISTICS lost
Date: 2010-03-26 16:05:38
Message-ID: 045.1a97e0cf84b2463e97291f0aa7b59cd6@code.pgadmin.org (view raw or flat)
Thread:
Lists: pgadmin-hackers
#160: STATISTICS lost
---------------------+------------------------------------------------------
 Reporter:  brsa     |       Owner:  dpage
     Type:  bug      |      Status:  new  
 Priority:  minor    |   Milestone:       
Component:  pgadmin  |     Version:  trunk
 Keywords:           |    Platform:  all  
---------------------+------------------------------------------------------
 The re-engineered SQL in the SQL pane of pgAdmin 1.10.2 misses out on
 column STATISTICS.

 Demo:
 ~~~~~
   -- I say --
 CREATE TABLE test
 ( test_id integer PRIMARY KEY,
   test text);
 ALTER TABLE test ALTER COLUMN test SET STATISTICS 0;

   -- pgAdmin says --
 CREATE TABLE test
 (
   test_id integer NOT NULL,
   test text,
   CONSTRAINT test_pkey PRIMARY KEY (test_id)
 )
 WITH (
   OIDS=FALSE
 );

 -- pd_dump would add:
 -- ALTER TABLE ONLY test ALTER COLUMN test SET STATISTICS 0;

-- 
Ticket URL: <http://code.pgadmin.org/trac/ticket/160>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

Responses

pgadmin-hackers by date

Next:From: pgAdmin TracDate: 2010-03-26 16:07:40
Subject: Re: [pgAdmin III] #160: column STATISTICS lost (was: STATISTICS lost)
Previous:From: Erwin BrandstetterDate: 2010-03-26 15:51:38
Subject: Bug with create function ... RETURNS TABLE

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