To Whom It May Concern:
I'm working on my first PostgreSQL project and have used
pgAdmin III with great success. Thank you for your work on this
application.
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.
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
);
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?
Joe Moyle
Sr. DBA
Paymetric Inc.
