| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Bjorn Metzdorf" <bm(at)turtle-entertainment(dot)de> |
| Cc: | "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: tsearch comments |
| Date: | 2003-01-23 15:14:05 |
| Message-ID: | 25872.1043334845@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Bjorn Metzdorf" <bm(at)turtle-entertainment(dot)de> writes:
> Btw, the error message was confusing. It said that the function has to be
> marked "isImmutable", but there is no such attribute, instead "iscachable"
> had to be used. This seems to be a bug.
Actually the preferred syntax in 7.3 is
CREATE FUNCTION ... LANGUAGE foo IMMUTABLE
For awhile during 7.3 development you had to write WITH (isImmutable)
but we changed the syntax to be more SQL-spec-compatible. This error
message seems not to have gotten fixed --- thanks for pointing it out.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-01-23 15:26:19 | Re: [PERFORM] optimizing query |
| Previous Message | Björn Metzdorf | 2003-01-23 15:09:27 | Re: tsearch comments |