Horton

Re: tsearch comments

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Bjorn Metzdorf" <bm@turtle-entertainment.de>
Cc: "Oleg Bartunov" <oleg@sai.msu.su>, pgsql-general@postgresql.org
Date: 2003-01-23T15:14:05Z
Lists: 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