Re: I need help creating a composite type with some sort of constraints.

From: Scott Bailey <artacus(at)comcast(dot)net>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: I need help creating a composite type with some sort of constraints.
Date: 2009-11-23 22:49:31
Message-ID: 4B0B117B.5000709@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John Oyler wrote:
> I can create one or more domains, and use those to create the
> composite type from. But each domain can only be constrained in its
> own value, I can't constrain element #1's value based on what element
> #2's value is.
>
> If I create a domain from a composite, it will complain with a "ERROR:
> cdt.instant_message is not a valid base type for a domain" error.
>
> I can't create a trigger for a composite either (technically it's not
> a table, but I was hoping it might be treated as one internally).
>
> Is there any way to do this? Are there any plans to change or expand
> this functionality in the future?
>
> Thanks,
> John O.

For now you have to put all checks in custom constructor functions.

Scott

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kris Gale 2009-11-23 23:08:17 Multicolumn index including tsvector.
Previous Message Alan Hodgson 2009-11-23 22:42:39 Re: get a log of queries that take up a lot of CPU or take a very long time.