Re: Recursive SQL functions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Recursive SQL functions
Date
Msg-id 22630.1003016351@sss.pgh.pa.us
Whole thread Raw
In response to Recursive SQL functions  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Pre-forking backend
Next
From: Tatsuo Ishii
Date:
Subject: Re: pg_client_encoding