On Thu, Sep 17, 2026 at 3:25 PM Mark Hill <[email protected]> wrote:
> We are trying to run this code in Postgres 18.6: > > *CREATE EXTENSION IF NOT EXISTS pgcrypto WITH SCHEMA pg_catalog CASCADE;* > > which try to create the gen_random_uuid() function but since it already > exists it throws an error. > > *1) Should pgcrytpo—1.3.sql be trying to create gen_random_uuid() if/when > it already exists?* > It's not expecting to be installed in the pg_catalog schema since it is an extension. Extensions don't usually conditionally install their components. > *2) given what’s in pgcrypto.control should there be a pgcrypto—1.4.sql > file?* > The pattern of a base full install and then incremental update scripts is supported. David J.
