| Lists: | pgsql-general |
|---|
| From: | John Oyler <john(dot)m(dot)oyler(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | ERROR: (custom type via CREATE TYPE) is not a valid base type for a domain |
| Date: | 2009-11-21 21:55:27 |
| Message-ID: | 3cc9797c0911211355i79f52b43xa06add9b0a28ef98@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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.
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | John Oyler <john(dot)m(dot)oyler(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ERROR: (custom type via CREATE TYPE) is not a valid base type for a domain |
| Date: | 2009-11-21 23:09:19 |
| Message-ID: | 20774.1258844959@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
John Oyler <john(dot)m(dot)oyler(at)gmail(dot)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
| From: | John Oyler <john(dot)m(dot)oyler(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ERROR: (custom type via CREATE TYPE) is not a valid base type for a domain |
| Date: | 2009-11-21 23:20:46 |
| Message-ID: | 3cc9797c0911211520u372a668ra845581a323452fb@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Yes. Sorry... brain fart, meant to type that instead.
John O.
On Sat, Nov 21, 2009 at 5:09 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> John Oyler <john(dot)m(dot)oyler(at)gmail(dot)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
>