Ticket #160 (closed bug: fixed)
column STATISTICS lost
| Reported by: | brsa | Owned by: | gleu |
|---|---|---|---|
| Priority: | minor | Milestone: | 1.10.3 |
| Component: | pgadmin | Version: | 1.10 |
| Keywords: | browser | Cc: | |
| Platform: | all |
Description
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;
Attachments
Change History
Note: See
TracTickets for help on using
tickets.

