pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
plpgsql error: cache lookup from pg_proc failed 3+ messages / 2 participants [nested] [flat]
* plpgsql error: cache lookup from pg_proc failed @ 2001-02-07 01:35 Joseph Shraibman <jks@selectacast.net> 0 siblings, 0 replies; 3+ messages in thread From: Joseph Shraibman @ 2001-02-07 01:35 UTC (permalink / raw) To: pgsql-sql playpen=# create table aa( playpen(# a int, playpen(# b int, playpen(# t timestamp playpen(# ); CREATE playpen=# playpen=# playpen=# CREATE FUNCTION touch () RETURNS OPAQUE AS ' playpen'# BEGIN playpen'# new.t := current_timestamp; playpen'# RETURN new; playpen'# END; playpen'# ' LANGUAGE 'plpgsql'; CREATE playpen=# playpen=# playpen=# CREATE TRIGGER lastmod_1 AFTER update or insert ON aa FOR EACH ROW EXECUTE PROCEDURE touch(); CREATE playpen=# insert into aa (a, b) values (1,2); ERROR: plpgsql: cache lookup from pg_proc failed What does this error message mean? -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com ^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: plpgsql error: cache lookup from pg_proc failed @ 2001-02-07 02:03 Michael Davis <mdavis@sevainc.com> 0 siblings, 1 reply; 3+ messages in thread From: Michael Davis @ 2001-02-07 02:03 UTC (permalink / raw) To: 'Joseph Shraibman' <jks@selectacast.net>; pgsql-sql Setting NEW in an AFTER update or insert trigger is not wise. Try using a before update trigger instead. -----Original Message----- From: Joseph Shraibman [SMTP:jks@selectacast.net] Sent: Tuesday, February 06, 2001 6:35 PM To: pgsql-sql@postgresql.org Subject: plpgsql error: cache lookup from pg_proc failed playpen=# create table aa( playpen(# a int, playpen(# b int, playpen(# t timestamp playpen(# ); CREATE playpen=# playpen=# playpen=# CREATE FUNCTION touch () RETURNS OPAQUE AS ' playpen'# BEGIN playpen'# new.t := current_timestamp; playpen'# RETURN new; playpen'# END; playpen'# ' LANGUAGE 'plpgsql'; CREATE playpen=# playpen=# playpen=# CREATE TRIGGER lastmod_1 AFTER update or insert ON aa FOR EACH ROW EXECUTE PROCEDURE touch(); CREATE playpen=# insert into aa (a, b) values (1,2); ERROR: plpgsql: cache lookup from pg_proc failed What does this error message mean? -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: RE: plpgsql error: cache lookup from pg_proc failed @ 2001-02-07 02:16 Joseph Shraibman <jks@selectacast.net> parent: Michael Davis <mdavis@sevainc.com> 0 siblings, 0 replies; 3+ messages in thread From: Joseph Shraibman @ 2001-02-07 02:16 UTC (permalink / raw) To: pgsql-sql; +Cc: mdavis@sevainc.com <mdavis@sevainc.com> Michael Davis wrote: > > Setting NEW in an AFTER update or insert trigger is not wise. Try using a before update trigger instead. > I still get the error message. > -----Original Message----- > From: Joseph Shraibman [SMTP:jks@selectacast.net] > Sent: Tuesday, February 06, 2001 6:35 PM > To: pgsql-sql@postgresql.org > Subject: plpgsql error: cache lookup from pg_proc failed > > playpen=# create table aa( > playpen(# a int, > playpen(# b int, > playpen(# t timestamp > playpen(# ); > CREATE > playpen=# > playpen=# > playpen=# CREATE FUNCTION touch () RETURNS OPAQUE AS ' > playpen'# BEGIN > playpen'# new.t := current_timestamp; > playpen'# RETURN new; > playpen'# END; > playpen'# ' LANGUAGE 'plpgsql'; > CREATE > playpen=# > playpen=# > playpen=# CREATE TRIGGER lastmod_1 AFTER update or insert ON aa FOR EACH > ROW EXECUTE PROCEDURE touch(); > CREATE > playpen=# insert into aa (a, b) values (1,2); > ERROR: plpgsql: cache lookup from pg_proc failed > > What does this error message mean? > -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-02-07 02:16 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-02-07 01:35 plpgsql error: cache lookup from pg_proc failed Joseph Shraibman <jks@selectacast.net> 2001-02-07 02:03 RE: plpgsql error: cache lookup from pg_proc failed Michael Davis <mdavis@sevainc.com> 2001-02-07 02:16 ` Joseph Shraibman <jks@selectacast.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox