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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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