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.
