Re: stable functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vincenzo Romano <vincenzo(dot)romano(at)gmail(dot)com>
Cc: "Filip =?utf-8?q?Rembia=C5=82kowski?=" <plk(dot)zuber(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: stable functions
Date: 2007-05-31 14:27:35
Message-ID: 29266.1180621655@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vincenzo Romano <vincenzo(dot)romano(at)gmail(dot)com> writes:
> <quote>
>> STABLE indicates that the function cannot modify the database,

> They talk about table scans which should not involce the information schema
> tables, the only tables that get modified by a fubction whose sole effect it
> to create other functions.creatorfunc

Modifying the system catalogs counts as modifying the database.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-05-31 14:32:12 Re: Operator whit word
Previous Message gonzales 2007-05-31 14:26:20 Re: jdbc pg_hba.conf error