Re: plpgsql exception handling

On Wed, Mar 9, 2011 at 2:08 PM, Samuel Gendler
<sgendler@ideasculptor.com> wrote:
> when I run 'select 1count(*) from table' in my postgres 8.4 installation, I
> get the exact same error message.  Assuming the '1count()' function does
> exist, perhaps you need to full qualify it with a schema name?
> It looks to me like the query you are passing to the procedure is invalid
> and is generating the error.  Perhaps the 1 in front of count(*) is a typo?

Also seem to be missing "p_id" from your execute statement:

execute 'create table result_'|| p_id ||' as '||p_sql;