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'