Skip site navigation (1) Skip section navigation (2)

Re: Update problem

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 (view raw or flat)
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
>

In response to

Responses

pgsql-sql by date

Next:From: samantha mahindrakarDate: 2008-06-03 20:53:10
Subject: Re: Update problem
Previous:From: samantha mahindrakarDate: 2008-06-03 19:00:10
Subject: Update problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group