Re: Recursive SQL functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Recursive SQL functions
Date: 2001-10-13 23:39:11
Message-ID: 22630.1003016351@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> I was wondering whether, as a future project, we could make this more
> convenient by parsing the body of the function with the binding of the
> function already in effect.

Seems like a simple rearrangement of the code. First insert the pg_proc
entry, then CommandCounterIncrement, then do the parsing/checking of the
function body. Given the CCI, the new entry will be visible for the
checking --- and if we error out, it rolls back just fine anyway.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2001-10-14 02:13:45 Re: pg_client_encoding
Previous Message Bill Studenmund 2001-10-13 23:38:20 Re: Package support for Postgres