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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | pgAdmin Trac | 2010-03-26 16:07:40 | Re: [pgAdmin III] #160: column STATISTICS lost (was: STATISTICS lost) |
Previous Message | Erwin Brandstetter | 2010-03-26 15:51:38 | Bug with create function ... RETURNS TABLE |