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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
