Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group