This is a multi-part message in MIME format.
------_=_NextPart_001_01C877F4.750F1924
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
To Whom It May Concern:
=20
I'm working on my first PostgreSQL project and have used
pgAdmin III with great success. Thank you for your work on this
application. =20
=20
I'm using Version 1.8.2 (Feb 4 2008, rev: 7050). When I browse the
schema in Object Browser I don't see my user defined Types in the tree.
Perhaps I'm just not looking in the right place. I search on Type in
Help but failed to find it. Let me show you a tiny snippet of the code
I'm running that creates a type so you see what I mean.
=20
CREATE TYPE "EMS"."Action_By_Hour"
AS (
"Day" DOUBLE
PRECISION
,"Descr" CHARACTER
VARYING(256)
,"Hour" DOUBLE
PRECISION
,"Month" DOUBLE PRECISION
,"Success" BOOLEAN
,"User_Name" CHARACTER VARYING(64)
,"Volume_Count" BIGINT
,"Year" DOUBLE
PRECISION
);
=20
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 sup****ted by pgAdmin III yet?
=20
Joe Moyle
Sr. DBA
Paymetric Inc.
=20
------_=_NextPart_001_01C877F4.750F1924
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@[EMAIL PROTECTED]
Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>To Whom It May Concern:<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'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. =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal style=3D'text-indent:.5in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>I’m using Version =
1.8.2 (Feb 4
2008, rev: 7050). When I browse the schema in Object Browser I =
don’t
see my user defined Types in the tree. Perhaps I’m just not =
looking
in the right place. I search on Type in Help but failed to find =
it.
Let me show you a tiny snippet of the code I’m running that =
creates a
type so you see what I mean.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> =
CREATE
TYPE "<st1:place =
w:st=3D"on">EMS</st1:place>"."Action_By_Hour"<o:p></o:p></=
span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> =
AS =
(<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> =
&=
nbsp; =
"Day" &nbs=
p;  =
; DOUBLE
PRECISION<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> =
&=
nbsp; =
,"Descr" &=
nbsp; &n=
bsp; CHARACTER
VARYING(256)<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> =
&=
nbsp; =
,"Hour" &n=
bsp; &nb=
sp; DOUBLE
PRECISION<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> =
&=
nbsp; =
,"Month" &=
nbsp; &n=
bsp; DOUBLE
PRECISION<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> =
&=
nbsp; =
,"Success"  =
; =
BOOLEAN<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> =
&=
nbsp; ,"User_Name" CHARACTER
VARYING(64)<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> =
&=
nbsp; =
,"Volume_Count" =
BIGINT<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> =
&=
nbsp; =
,"Year" &n=
bsp; &nb=
sp; DOUBLE
PRECISION<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> =
&=
nbsp; );<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> =
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 =
sup****ted
by pgAdmin III yet?<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><st1:PersonName w:st=3D"on"><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>Joe =
Moyle</span></font></st1:PersonName><o:p></o:p></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Sr. DBA</span></font><o:p></o:p></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Paymetric Inc.</span></font><o:p></o:p></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
------_=_NextPart_001_01C877F4.750F1924--
|
