Re: plpgsql_check_function - rebase for 9.3 - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: plpgsql_check_function - rebase for 9.3
Date
Msg-id 52A632B7.6030804@nasby.net
Whole thread Raw
In response to Re: plpgsql_check_function - rebase for 9.3  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
On 12/9/13 1:08 PM, Pavel Stehule wrote:
>     So presumably it would be check_never, not check_newer... :) BTW, it's not terribly hard to work around the temp
tableissue; you just need to create the expected table in the session when you create the function. But even in this
case,I think it would still be good to check what we can, like at least basic plpgsql syntax.
 
>
>
> I sorry.
>
> You cannot to create temporary table - this check should not have any side effect - and creating temporary table can
runsome event trigger.
 
>
> But there should be some hints for check like annotations or some similar. Or you can minimize a area where check
willbe disabled.
 

Sorry, I meant that the user can work around it by creating the table. I didn't mean to imply that we would magically
createa temp table to do the checking.
 
-- 
Jim C. Nasby, Data Architect                       jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: GIN improvements part 1: additional information
Next
From: Jeff Janes
Date:
Subject: Re: ANALYZE sampling is too good