[pgAdmin III] #160: STATISTICS lost
От | pgAdmin Trac |
---|---|
Тема | [pgAdmin III] #160: STATISTICS lost |
Дата | |
Msg-id | 045.1a97e0cf84b2463e97291f0aa7b59cd6@code.pgadmin.org обсуждение исходный текст |
Ответы |
Re: [pgAdmin III] #160: column STATISTICS lost (was: STATISTICS
lost)
Re: [pgAdmin III] #160: column STATISTICS lost Re: [pgAdmin III] #160: column STATISTICS lost |
Список | 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
В списке pgadmin-hackers по дате отправления: