From: | Uwe Bartels <uwe(dot)bartels(at)gmail(dot)com> |
---|---|
To: | bricklen <bricklen(at)gmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: plpgsql exception handling |
Date: | 2011-03-10 08:45:45 |
Message-ID: | AANLkTi=M5wCQe9wvn7SXdMrsmLmTLr_s1yrb_L9CSEBt@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
yes, p_id is a variable in my code which is bigger. so ignore the update
statement.
Uwe
On 10 March 2011 01:20, bricklen <bricklen(at)gmail(dot)com> wrote:
> On Wed, Mar 9, 2011 at 2:08 PM, Samuel Gendler
> <sgendler(at)ideasculptor(dot)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;
>
From | Date | Subject | |
---|---|---|---|
Next Message | Samuel Gendler | 2011-03-10 09:56:45 | Re: plpgsql exception handling |
Previous Message | Uwe Bartels | 2011-03-10 08:45:05 | Re: plpgsql exception handling |