Creating Extension pg_trgm

itishree sukla <itishree.sukla@gmail.com> writes:

I need to create pg_trgm extension, however in my current DB, we have some
function based on pg_trgm. when i am trying to create extension, it is
asking to drop all dependant function, is there anyway without dropping
any dependency i can create this extension.

It sounds like what you're really trying to do is update a pre-extensions
installation of pg_trgm into extension form. "CREATE EXTENSION pg_trgm
FROM unpackaged" should do that.

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general