Re: Auto-timestamp generator (attached) - Mailing list pgsql-general

From Tom Lane
Subject Re: Auto-timestamp generator (attached)
Date
Msg-id 14876.981678477@sss.pgh.pa.us
Whole thread Raw
In response to Re: Auto-timestamp generator (attached)  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
Joseph Shraibman <jks@selectacast.net> writes:
> It is persisting accross backend restarts, and on a newly created
> database too.  There are no views, rules, or triggers on this database.

Oh?  That's interesting.  It might help to patch
src/pl/plpgsql/src/pl_comp.c to show you the OID that it's unhappy about
... um ... waitasec.  7.0.* already *has* that patch.  If you're getting
an error message that doesn't mention an OID, you must be running a
7.0.0 or older plpgsql.  That might not play too well with a post-7.0
backend.  Check the path that's defined for the plpgsql shlib.

            regards, tom lane

pgsql-general by date:

Previous
From: Ben Leslie
Date:
Subject: Database and table name case sensitivity
Next
From: Joseph Shraibman
Date:
Subject: Re: Auto-timestamp generator (attached)