Created Type's not displayed in schema

Поиск
Список
Период
Сортировка
От Joe Moyle
Тема Created Type's not displayed in schema
Дата
Msg-id 8B1D2F832D92D84BB2C583614AAD7C090663C500@pmmail02.paymetric.com
обсуждение исходный текст
Ответы Re: Created Type's not displayed in schema
Список pgadmin-support
<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>

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

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: Small feature request for pgadmin 1.8.2: in Create script window show merged columns as '-- Merged' instead of '-- Inherited'
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Created Type's not displayed in schema