pgAdmin table structure dispay issue

Поиск
Список
Период
Сортировка
От Dustin
Тема pgAdmin table structure dispay issue
Дата
Msg-id AANLkTimv9coOhwHiVMf+R0pusn=YM1=jZ=0OS9X9P6BY@mail.gmail.com
обсуждение исходный текст
Ответы Re: pgAdmin table structure dispay issue  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-support
<p class="MsoNormal">pgAdmin version: 1.12.2 (Dec 13, 2010, rev: REL-1_12_2)<p class="MsoNormal">Operating System:
WindowsXP Pro SP 3<p class="MsoNormal">PostGreSQL Server Version: PostgreSQL 9.0.2 on x86_64-unknown-linux-gnu,
compiledby GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48), 64-bit<span style="">              </span><p
class="MsoNormal"> <pclass="MsoNormal">Issue:<p class="MsoNormal">It seems that on some tables, there are columns that
areshowing up more than once in the SQL Pane. Here is an example:<p class="MsoNormal"> <p class="MsoNormal">CREATE
TABLEuniverse<p class="MsoNormal">(<p class="MsoNormal"><span style="">  </span>id serial NOT NULL,<p
class="MsoNormal"><spanstyle="">  </span>id serial NOT NULL,<p class="MsoNormal"><span style="">  </span>id serial NOT
NULL,<pclass="MsoNormal"><span style="">  </span>id serial NOT NULL,<p class="MsoNormal"><span style="">  </span>id
serialNOT NULL,<p class="MsoNormal"><span style="">  </span>mfgno character varying(32) NOT NULL,<p
class="MsoNormal"><spanstyle="">  </span>mfgno_stripped character varying(32) NOT NULL,<p class="MsoNormal"><span
style=""> </span>man_id smallint NOT NULL,<p class="MsoNormal"><span style="">  </span>etilize_id integer,<p
class="MsoNormal"><spanstyle="">  </span>upc character varying(32),<p class="MsoNormal"><span style="">  </span>"name"
charactervarying(500),<p class="MsoNormal"><span style="">  </span>keywords text,<p class="MsoNormal"><span style=""> 
</span>categoryidcharacter varying(25),<p class="MsoNormal"><span style="">  </span>ts_mfgno_name_keywords tsvector,<p
class="MsoNormal"><spanstyle="">  </span>img character varying(255),<p class="MsoNormal"><span style=""> 
</span>CONSTRAINTuniverse_pkey PRIMARY KEY (id),<p class="MsoNormal"><span style="">  </span>CONSTRAINT
universe_mfgno_stripped_man_id_keyUNIQUE (mfgno_stripped, man_id)<p class="MsoNormal">)<p class="MsoNormal">WITH (<p
class="MsoNormal"><spanstyle="">  </span>OIDS=TRUE<p class="MsoNormal">);<p class="MsoNormal"> <p
class="MsoNormal">Hereis the output from the same server running “\d+ public.universe”:<p class="MsoNormal"> <p
class="MsoNormal">#\d+ public.universe<p class="MsoNormal"><span
style="">                                                    </span>Table "public.universe"<p class="MsoNormal"><span
style="">        </span>Column<span style="">         </span>|<span style="">          </span>Type<span
style="">         </span>|<span style="">                       </span>Modifiers<span style="">                      
</span>|Storage<span style="">  </span>| Description<p
class="MsoNormal">------------------------+------------------------+-------------------------------------------------------+----------+-------------<p
class="MsoNormal"><spanstyle=""> </span>id<span style="">                     </span>| integer<span
style="">               </span>| not null default nextval('universe_id_seq'::regclass) | plain<span style="">   
</span>|<pclass="MsoNormal"><span style=""> </span>mfgno<span style="">                  </span>| character
varying(32)<spanstyle="">  </span>| not null<span style="">                                              </span>|
extended|<p class="MsoNormal"><span style=""> </span>mfgno_stripped<span style="">         </span>| character
varying(32)<spanstyle="">  </span>| not null<span style="">                                              </span>|
extended|<p class="MsoNormal"><span style=""> </span>man_id<span style="">                 </span>| smallint<span
style="">              </span>| not null<span style="">                                              </span>|
plain<spanstyle="">    </span>|<p class="MsoNormal"><span style=""> </span>etilize_id<span style="">         
</span><spanstyle="">   </span>| integer<span style="">                </span>|<span
style="">                                                      </span>| plain<span style="">    </span>|<p
class="MsoNormal"><spanstyle=""> </span>upc<span style="">                    </span>| character varying(32)<span
style=""> </span>|<span style="">                                                       </span>| extended |<p
class="MsoNormal"><spanstyle=""> </span>name<span style="">                   </span>| character varying(500) |<span
style="">                                                      </span>| extended |<p class="MsoNormal"><span
style=""> </span>keywords<spanstyle="">               </span>| text<span style="">                   </span>|<span
style="">                                                      </span>| extended |<p class="MsoNormal"><span
style=""> </span>categoryid<spanstyle="">             </span>| character varying(25)<span style="">  </span>|<span
style="">                                                      </span>| extended |<p class="MsoNormal"><span
style=""> </span>ts_mfgno_name_keywords| tsvector<span style="">               </span>|<span
style="">                                                      </span>| extended |<p class="MsoNormal"><span
style=""> </span>img<spanstyle="">                </span><span style="">    </span>| character varying(255) |<span
style="">                                                      </span>| extended |<p class="MsoNormal">Indexes:<p
class="MsoNormal"><spanstyle="">    </span>"universe_pkey" PRIMARY KEY, btree (id)<p class="MsoNormal"><span
style="">   </span>"universe_mfgno_stripped_man_id_key" UNIQUE, btree (mfgno_stripped, man_id)<p
class="MsoNormal"><spanstyle="">    </span>"universe_categoryid" btree (categoryid)<p class="MsoNormal"><span
style="">   </span>"universe_etilize_id" btree (etilize_id)<p class="MsoNormal"><span style="">   
</span>"universe_man_id_idx"btree (man_id)<p class="MsoNormal"><span style="">    </span>"universe_name_ts" gin
(to_tsvector('english'::regconfig,name::text))<p class="MsoNormal"><span style="">   
</span>"universe_ts_mfgno_name_keywords"gin (ts_mfgno_name_keywords)<p class="MsoNormal"><span style="">   
</span>"universe_ts_substring_mfgno_stripped"gin (to_tsvector('simple'::regconfig,
text_to_trigrams(mfgno_stripped)::text))<pclass="MsoNormal">Referenced by:<p class="MsoNormal"><span style="">   
</span>TABLE"google.adwords" CONSTRAINT "adwords_universe_id_fkey" FOREIGN KEY (universe_id) REFERENCES universe(id)<p
class="MsoNormal"><spanstyle="">    </span>TABLE "promotions.products" CONSTRAINT "products_universe_id_fkey" FOREIGN
KEY(universe_id) REFERENCES universe(id) ON DELETE CASCADE<p class="MsoNormal"><span style="">    </span>TABLE
"offers.rebates_products"CONSTRAINT "rebates_products_universe_id_fkey" FOREIGN KEY (universe_id) REFERENCES
universe(id)ON DELETE CASCADE<p class="MsoNormal"><span style="">    </span>TABLE "aff.clicks" CONSTRAINT
"universe_id_fkey"FOREIGN KEY (universe_id) REFERENCES universe(id)<p class="MsoNormal"><span style="">    </span>TABLE
"exports.exclude_exempt"CONSTRAINT "universe_id_fkey" FOREIGN KEY (universe_id) REFERENCES universe(id)<p
class="MsoNormal"><spanstyle="">    </span>TABLE "aff.clicks_daily" CONSTRAINT "universe_id_fkey" FOREIGN KEY
(universe_id)REFERENCES universe(id)<p class="MsoNormal"><span style="">    </span>TABLE "exports.exclude" CONSTRAINT
"universe_id_fkey"FOREIGN KEY (universe_id) REFERENCES universe(id)<p class="MsoNormal">Triggers:<p
class="MsoNormal"><spanstyle="">    </span>etilize_map_universe BEFORE INSERT ON universe FOR EACH ROW EXECUTE
PROCEDUREuniverse_map_etilize()<p class="MsoNormal"><span style="">    </span>ts_mfgno_name_keywords_update BEFORE
INSERTOR UPDATE ON universe FOR EACH ROW EXECUTE PROCEDURE tsvector_universe_trigger()<p class="MsoNormal">Has OIDs:
yes<pclass="MsoNormal"> <p class="MsoNormal">This issue was not present before I upgraded to the newest version of
pgAdmin.<pclass="MsoNormal"> <p class="MsoNormal">Thanks,<p class="MsoNormal"> <p class="MsoNormal"><a
name="_MailAutoSig"><spanstyle="">Dustin</span></a><span style=""></span><p class="MsoNormal">  

В списке pgadmin-support по дате отправления:

Предыдущее
От: Stane Mikolič
Дата:
Сообщение: Re: pgAgent installation fails - LIBPQ.DLL is missing - PostgreSQL 9.0.2 x64 - 2008 Windows Server x64
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: pgAdmin table structure dispay issue