pgAdmin version: 1.12.2 (Dec 13, 2010, rev: REL-1_12_2)
Operating System: Windows XP Pro SP 3
PostGreSQL Server Version: PostgreSQL 9.0.2 on x86_64-unknown-linux-gnu,
compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48), 64-bit
Issue:
It seems that on some tables, there are columns that are showing up more
than once in the SQL Pane. Here is an example:
CREATE TABLE universe
(
id serial NOT NULL,
id serial NOT NULL,
id serial NOT NULL,
id serial NOT NULL,
id serial NOT NULL,
mfgno character varying(32) NOT NULL,
mfgno_stripped character varying(32) NOT NULL,
man_id smallint NOT NULL,
etilize_id integer,
upc character varying(32),
"name" character varying(500),
keywords text,
categoryid character varying(25),
ts_mfgno_name_keywords tsvector,
img character varying(255),
CONSTRAINT universe_pkey PRIMARY KEY (id),
CONSTRAINT universe_mfgno_stripped_man_id_key UNIQUE (mfgno_stripped,
man_id)
)
WITH (
OIDS=TRUE
);
Here is the output from the same server running “\d+ public.universe”:
# \d+ public.universe
Table "public.universe"
Column | Type |
Modifiers | Storage | Description
------------------------+------------------------+-------------------------------------------------------+----------+-------------
id | integer | not null default
nextval('universe_id_seq'::regclass) | plain |
mfgno | character varying(32) | not null
| extended |
mfgno_stripped | character varying(32) | not null
| extended |
man_id | smallint | not null
| plain |
etilize_id | integer |
| plain |
upc | character varying(32) |
| extended |
name | character varying(500) |
| extended |
keywords | text |
| extended |
categoryid | character varying(25) |
| extended |
ts_mfgno_name_keywords | tsvector |
| extended |
img | character varying(255) |
| extended |
Indexes:
"universe_pkey" PRIMARY KEY, btree (id)
"universe_mfgno_stripped_man_id_key" UNIQUE, btree (mfgno_stripped,
man_id)
"universe_categoryid" btree (categoryid)
"universe_etilize_id" btree (etilize_id)
"universe_man_id_idx" btree (man_id)
"universe_name_ts" gin (to_tsvector('english'::regconfig, name::text))
"universe_ts_mfgno_name_keywords" gin (ts_mfgno_name_keywords)
"universe_ts_substring_mfgno_stripped" gin
(to_tsvector('simple'::regconfig, text_to_trigrams(mfgno_stripped)::text))
Referenced by:
TABLE "google.adwords" CONSTRAINT "adwords_universe_id_fkey" FOREIGN KEY
(universe_id) REFERENCES universe(id)
TABLE "promotions.products" CONSTRAINT "products_universe_id_fkey"
FOREIGN KEY (universe_id) REFERENCES universe(id) ON DELETE CASCADE
TABLE "offers.rebates_products" CONSTRAINT
"rebates_products_universe_id_fkey" FOREIGN KEY (universe_id) REFERENCES
universe(id) ON DELETE CASCADE
TABLE "aff.clicks" CONSTRAINT "universe_id_fkey" FOREIGN KEY
(universe_id) REFERENCES universe(id)
TABLE "exports.exclude_exempt" CONSTRAINT "universe_id_fkey" FOREIGN KEY
(universe_id) REFERENCES universe(id)
TABLE "aff.clicks_daily" CONSTRAINT "universe_id_fkey" FOREIGN KEY
(universe_id) REFERENCES universe(id)
TABLE "exports.exclude" CONSTRAINT "universe_id_fkey" FOREIGN KEY
(universe_id) REFERENCES universe(id)
Triggers:
etilize_map_universe BEFORE INSERT ON universe FOR EACH ROW EXECUTE
PROCEDURE universe_map_etilize()
ts_mfgno_name_keywords_update BEFORE INSERT OR UPDATE ON universe FOR
EACH ROW EXECUTE PROCEDURE tsvector_universe_trigger()
Has OIDs: yes
This issue was not present before I upgraded to the newest version of
pgAdmin.
Thanks,
Dustin
