On Thu, Apr 17, 2014 at 6:51 PM, Alvaro Herrera <
alvherre@2ndquadrant.com> wrote:
>
> It does sounds a legitimate feature request to me. I don't remember if
> we honored the request to add resetting of cached sequences, though; if
> we didn't, this one is probably going to be tough too.
>
+1
> Another point is that to implement this I think there will need to be
> another per-PL entry point to discard session data; are we okay with
> that? Since this probably means a new column in pg_language, we
> couldn't even consider the idea of back-patching. Unless we add a hook,
> which is registered in the PL's _PG_init()?
>
This week I had some similar trouble, but using "dblink" and "pgbouncer".
As expected "DISCARD ALL" don't clear the extension resources.