Upgrade to 9.1 causing function problem - Mailing list pgsql-general

From Willem Buitendyk
Subject Upgrade to 9.1 causing function problem
Date
Msg-id CCCE766E-F1B1-448D-803B-F410A94F6AA2@pcfish.ca
Whole thread Raw
Responses Re: Upgrade to 9.1 causing function problem
List pgsql-general
I have recently upgraded my database from 8.4 to 9.1.  In the process I have moved everything to a different schema.
Postgisis occupying the public schema.  Everything is working fine except for some of my own functions. Here is a small
functionand table that will not update when I perform the following code:    select
_me_set_process_month('2012-01-01');    It will run but the resulting table will not update.  Any ideas? 


CREATE OR REPLACE FUNCTION _me_set_process_month(date)
  RETURNS void AS
$BODY$

BEGIN

update activity_month set action_month = $1;


END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION _me_set_process_month(date)
  OWNER TO postgres;



CREATE TABLE activity_month
(
  action_month date NOT NULL,
  CONSTRAINT idkeymonth PRIMARY KEY (action_month )
)
WITH (
  OIDS=FALSE
);
ALTER TABLE activity_month
  OWNER TO postgres;
GRANT ALL ON TABLE activity_month TO public;
GRANT ALL ON TABLE activity_month TO postgres;

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Optimise PostgreSQL for fast testing
Next
From: Adrian Klaver
Date:
Subject: Re: Upgrade to 9.1 causing function problem