#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

-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Reply via email to