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

Re: [SQL] ERROR: missing FROM-clause entry for table "new"

> I'm trying to define a trigger function that looks for changes in table A > (table the trigger for the function is on) and write a delta record into table > B. So if a record has a value of 100 in table A, and it is updated to 50, the > function should write ­50 in table B. I can get the trigger

[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';