I tried getting the output of the execute statements by printing the
FOUND variable. It is returning the value as false.
However i used PEFORM instead of EXECUTE for the update statement. It
On 6/3/08, samantha mahindrakar <sam(dot)mahindrakar(at)gmail(dot)com> wrote:
> Iam facing a strange issue....
> One of the functions in my program is running an update statement. The
> statement is running cross-schema. What i mean is that the program
> resides in one schema where as it updates a table from another schema.
> How ever these scehmas are on the same database.
> The program runs correctly and also prints out the update statement.
> But it never actually updates the table.....neither does it fail.
> However when i run one of the update statements individually in the
> query tool...the update happens.
> Iam assuming that this is not a problem with the permissions either
> since the permission for the table to be updated is set to public.
> iam pasting the update statement for reference:
> EXECUTE 'UPDATE '||thepartition||' SET
> WHERE lane_id='||lane||' and measurement_start =
In response to
pgsql-sql by date
|Next:||From: samantha mahindrakar||Date: 2008-06-03 20:53:10|
|Subject: Re: Update problem|
|Previous:||From: samantha mahindrakar||Date: 2008-06-03 19:00:10|
|Subject: Update problem|