Thread: ERROR: (custom type via CREATE TYPE) is not a valid base type for a domain
I receive this error message whenever I attempt to create a domain from a custom type, but Google comes up short on explanations. A few mailing list messages touch on the subject, but nothing like the details on just where the limits lay or why they are as they are (or even if work is being done on this, and a new version might allow this someday). I was hoping to create a domain so that I could constrain the value of one of the elements dependent on the value of the other element(s). Can anyone shed some light on this? Thanks, John O.
John Oyler <john.m.oyler@gmail.com> writes:
> I receive this error message whenever I attempt to create a domain
> from a custom type,
By "custom type" do you mean a composite type? We don't have domains
over composites, I believe.
regards, tom lane
Re: ERROR: (custom type via CREATE TYPE) is not a valid base type for a domain
From
John Oyler
Date:
Yes. Sorry... brain fart, meant to type that instead. John O. On Sat, Nov 21, 2009 at 5:09 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > John Oyler <john.m.oyler@gmail.com> writes: >> I receive this error message whenever I attempt to create a domain >> from a custom type, > > By "custom type" do you mean a composite type? We don't have domains > over composites, I believe. > > regards, tom lane >