A postgres tip
(ServerLinux) I needed to do some calculation on a postgres function so i had to use plpgsql. I also had to return a set of records. To do this i instintivelly used a 'return setof record' and defined a variable'ret_row record' but i got this error:Query failed:
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 14157 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 14157]
updated 14157 (Linux Server Security Secrets), inserted 2, updated 0, at 2012-06-01 21:51:29
Articles from: Linux Server Security Secrets (ServerLinux)
