Re: Composite UNIQUE across two tables?

On 3/7/08, Jamie Tufnell <diesql(at)googlemail(dot)com> wrote:
> On 3/7/08, Bart Degryse <Bart(dot)Degryse(at)indicator(dot)be> wrote:
> > I haven't tested these two statements, but I'm using exactly this
> > concept on some tables myself.
> > My equivalent of your users table contains some 3,000,000 records.
> > My equivalent of your sites table contains some 150,000 records.
> > And it works fine...
> When I try to create the index I get the following error:
>
> ERROR: functions in index expression must be marked IMMUTABLE
>
> Out of curiosity, I declared it IMMUTABLE and it worked for the
> purposes of my small, isolated test,.
>
> Am I opening myself up to problems by doing this?

Does anyone have any comment on this? I've done some more testing and
have yet to run into a problem.

I'd be really interested to hear some opinions on this.

Cheers,
J.