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

Re: Recursion and SPI

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ian Lance Taylor <ian(at)airs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Recursion and SPI
Date: 2001-01-05 23:03:54
Message-ID: 15140.978735834@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Ian Lance Taylor <ian(at)airs(dot)com> writes:
> Does the SPI interface support recursion?  That is, can a function
> use SPI to make a query which involves calling another function which
> uses SPI?

Looks to me like it should work.

> The documentation suggests not, saying that if a function which uses
> SPI calls another function which uses SPI, it won't work, and calling
> that ``bad practice.''

The documentation could be out of date.  Why don't you test it out and
let us know?

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Alex PilosovDate: 2001-01-05 23:06:55
Subject: Re: SHM ids (was running pgsql 7 under Jail'ed virtual machine on FreeBSD 4.2)
Previous:From: Tom LaneDate: 2001-01-05 23:01:48
Subject: Re: SHM ids (was running pgsql 7 under Jail'ed virtual machine on FreeBSD 4.2)

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