Re: Foreign Exclusion Constraints

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: Nathan Boley <npboley(at)gmail(dot)com>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Foreign Exclusion Constraints
Date: 2013-02-21 04:05:05
Message-ID: CAL_0b1sMdB79L2HcHx4tb-oLgpWVJvMruqs2nsqS81HZ9dwarA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Feb 20, 2013 at 2:34 PM, Nathan Boley <npboley(at)gmail(dot)com> wrote:
> I'm trying to store exons that must fit within a chromosome, but the
> chromosomes all have different lengths, so I want a check constraint
> so that location is contained within CHR_RANGE where CHR_RANGE is
> taken from the chromosomes table.
>
> Can I add that constraint without a trigger?

No, you can't.

There is nothing wrong in doing it with triggers BTW.

>
> The archives seem to say no, but I thought I'd ask...
>
> http://www.postgresql.org/message-id/1288033876.6278.6.camel@vanquo.pezone.net
> http://www.postgresql.org/message-id/CACECd8i4P4iNqUii4Lqsw0qSthawhh3gE=AtmBDSJN25qrx15g@mail.gmail.com
> http://www.postgresql.org/message-id/1678334.8llTyI05Te@hek506
>
> Thanks,
> Nathan Boley
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

--
Sergey Konoplev
Database and Software Architect
http://www.linkedin.com/in/grayhemp

Phones:
USA +1 415 867 9984
Russia, Moscow +7 901 903 0499
Russia, Krasnodar +7 988 888 1979

Skype: gray-hemp
Jabber: gray(dot)ru(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Seref Arikan 2013-02-21 10:31:46 Re: subselects vs WITH in views
Previous Message Kirk Wythers 2013-02-21 00:19:34 Re: PostgreSQL took over my login