Update problem

From: "samantha mahindrakar" <sam(dot)mahindrakar(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Update problem
Date: 2008-06-03 19:00:10
Message-ID: f0c828c40806031200q14f9a5a5g3d90674099b4b56@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message samantha mahindrakar 2008-06-03 20:48:26 Re: Update problem
Previous Message Pavel Stehule 2008-06-03 16:14:44 Re: function returning result set of varying column