Обсуждение: Created Type's not displayed in schema

Поиск
Список
Период
Сортировка

Created Type's not displayed in schema

От
"Joe Moyle"
Дата:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">To Whom It May Concern:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">            </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">            I’m working on my first PostgreSQL project and have used pgAdmin III with great
success. Thank you for your work on this application.  </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal" style="text-indent:.5in"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">I’musing Version 1.8.2 (Feb 4 2008, rev: 7050).  When I browse the schema in
ObjectBrowser I don’t see my user defined Types in the tree.  Perhaps I’m just not looking in the right place.  I
searchon Type in Help but failed to find it.  Let me show you a tiny snippet of the code I’m running that creates a
typeso you see what I mean.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">            CREATE TYPE "EMS"."Action_By_Hour"</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">            AS        (</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">                        "Day"                            DOUBLE PRECISION</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">                        ,"Descr"                        CHARACTER VARYING(256)</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">                        ,"Hour"                          DOUBLE PRECISION</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">                        ,"Month"                        DOUBLE PRECISION</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">                        ,"Success"                    BOOLEAN</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">                        ,"User_Name"    CHARACTER VARYING(64)</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">                        ,"Volume_Count"           BIGINT</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial">                        ,"Year"                          DOUBLE PRECISION</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">                        );</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">            I only see Domains, Functions, Sequences, Tables, Trigger Functions, and Views in my
schemabut not my Types.  Is this something I’m just not configuring to display properly or is this type of schema
objectnot supported by pgAdmin III yet?</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">JoeMoyle</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">Sr. DBA</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Paymetric Inc.</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size:
12.0pt"> </span></font></div>

Re: Created Type's not displayed in schema

От
Guillaume Lelarge
Дата:
Joe Moyle a écrit :
> [...]
>             I only see Domains, Functions, Sequences, Tables, Trigger 
> Functions, and Views in my schema but not my Types.  Is this something 
> I’m just not configuring to display properly or is this type of schema 
> object not supported by pgAdmin III yet?
> 

Take a look in File/Options and select the Display tab. You'll find a 
list of objects' kinds that will show in the navigator pane if checked. 
So, check that the Type checkbox is checked. If not, check it.

Regards.


-- 
Guillaume. http://www.postgresqlfr.org http://dalibo.com