Re: tsearch comments - Mailing list pgsql-general

From Tom Lane
Subject Re: tsearch comments
Date
Msg-id 25872.1043334845@sss.pgh.pa.us
Whole thread Raw
In response to Re: tsearch comments  ("Bjorn Metzdorf" <bm@turtle-entertainment.de>)
List pgsql-general
"Bjorn Metzdorf" <bm@turtle-entertainment.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

pgsql-general by date:

Previous
From: Björn Metzdorf
Date:
Subject: Re: tsearch comments
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] optimizing query