[SQL] Problem with committing the update

Hi all, I have a problem updating the record using store procedure (LANGUAGE plpgsql).I have attach the query. http://postgresql.1045698.n5.nabble.com/file/n5723831/query.txt query.txt /SELECT id INTO STRICT temp_id from T_table_B where T_table_B.column_id = $1 and T_table_B.status = 'False';

Re: [SQL] pg_restore problem

On 09/14/2012 01:58 AM, Kjell Øygard wrote: 1 - Ok, I was not aware of that 2 - I used version 9.1.4 of pg_dump 3 - The command was in a script, se below pdir=/usr/local/postgresql-9.1.4/ bdir=/backup/`hostname -s`/dump/ export PATH=${pdir}/bin:$PATH # make sure tmp files are not readable