From: | "Jamie Tufnell" <diesql(at)googlemail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Composite UNIQUE across two tables? |
Date: | 2008-03-09 15:27:08 |
Message-ID: | b0a4f3350803090827p61b075c0rd27e63c2cb23ab93@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | A. R. Van Hook | 2008-03-09 21:02:53 | Insert problem |
Previous Message | Markus Schatten | 2008-03-08 14:07:35 | Re: plpythonu + os.spawnv |