From: | "samantha mahindrakar" <sam(dot)mahindrakar(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Update problem |
Date: | 2008-06-03 20:48:26 |
Message-ID: | f0c828c40806031348l48f23d99m22a4233130f73d17@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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:
> Hi....
> 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
> volume='||updated_volume||',occupancy='||updated_occ||',speed='||updated_speed||'
> WHERE lane_id='||lane||' and measurement_start =
> '''||measurement_start||'''';
>
>
> Thanks
> Sam
>
From | Date | Subject | |
---|---|---|---|
Next Message | samantha mahindrakar | 2008-06-03 20:53:10 | Re: Update problem |
Previous Message | samantha mahindrakar | 2008-06-03 19:00:10 | Update problem |