itishree sukla <itishree.sukla@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
