Re: 8.1 and syntax checking at create time - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: 8.1 and syntax checking at create time
Date
Msg-id 20050831193816.GE98175@pervasive.com
Whole thread Raw
In response to Re: 8.1 and syntax checking at create time  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On Wed, Aug 31, 2005 at 11:59:47AM -0700, Josh Berkus wrote:
> There is a  difference between *syntax* errors and *sql* errors.    If a 
> table does not exist, we don't want to check for that and bounce the 
> function; possibly the function will only be called in a context where the 
> table does exist.

It would still be nice to have, with a way to over-ride it, either via
an option to CREATE FUNCTION or with some directive to plpgsql itself
inside the function body (probably the most useful case since it allows
disabling error checking just where it's needed).
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software        http://pervasive.com        512-569-9461


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: 8.1 and syntax checking at create time
Next
From: Andrew Dunstan
Date:
Subject: Re: 8.1 and syntax checking at create time