pgAdmin table structure dispay issue

From: Dustin <deeluke(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAdmin table structure dispay issue
Date: 2011-01-25 22:26:17
Message-ID: AANLkTimv9coOhwHiVMf+R0pusn=YM1=jZ=0OS9X9P6BY@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2011-01-27 21:30:22 Re: pgAdmin table structure dispay issue
Previous Message Stane Mikolič 2011-01-21 22:03:34 Re: pgAgent installation fails - LIBPQ.DLL is missing - PostgreSQL 9.0.2 x64 - 2008 Windows Server x64