Problem with Entity Developer
Posted: Wed 25 May 2011 15:13
I have a PostgreSQL database with one schema in it (other than public). The schema includes the definitions of 2 composite types that are used as the return values for 2 different stored functions.
In the script where I create these types, they are clearly defined as belonging to my schema. That is, the statement begins with CREATE TYPE "MySchema"."MyType". I've triple checked the code & I'm not seeing things.
Yet, the Entity developer is giving me an error that says, "The Type MyType is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification." This makes no sense as the types are in a schema.
I've got 9 days left of my evaluation & this is the only tool for PostgreSQL I've found that actually seems to work. I've got to get this entity model working today of we're going to have to look elsewhere for a solution. Any help is greatly appreciated.
Tony
In the script where I create these types, they are clearly defined as belonging to my schema. That is, the statement begins with CREATE TYPE "MySchema"."MyType". I've triple checked the code & I'm not seeing things.
Yet, the Entity developer is giving me an error that says, "The Type MyType is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification." This makes no sense as the types are in a schema.
I've got 9 days left of my evaluation & this is the only tool for PostgreSQL I've found that actually seems to work. I've got to get this entity model working today of we're going to have to look elsewhere for a solution. Any help is greatly appreciated.
Tony