Thread: template1 changes in pre-existing databases

Hello

I was looking for a way to have new changes made to template1 affect
currently existing databases.  We have a new function that I want
available to all databases on our cluster, but don't want to have to
drop and recreate them. I'd also like to maintain the code in one place
only.

Is this possible? Is there a better way to do this?

Mija

Mija Lee <mija@scharp.org> writes:
> I was looking for a way to have new changes made to template1 affect
> currently existing databases.

> Is this possible?

Sorry, no.  You'll need to load the new function into all existing
databases separately.

            regards, tom lane