Enabling extensions on a compiled instance of postgresql 12.1

Hello I compiled from source postgresql 12.1 and all went fine but when I try to restore my DB I can see that I have 3 extensions missing: uuid-ossp, btree_gist, tablefunc. I tried to run: CREATE EXTENSION "uuid-ossp"; and the error is ERROR: could not open extension control file "/usr/local

Re[2]: Enabling extensions on a compiled instance of postgresql 12.1

It works. Thank you, thank you, thank you. -- Original Message -- From: "Julien Rouhaud" To: "Sterpu Victor" Cc: pgsql-gene...@postgresql.org Sent: 2020-02-13 3:48:08 PM Subject: Re: Enabling extensions on a compiled instance of postgresql 12.1 On Thu, Feb 13

Query to retrieve the index columns when a function is used.

Hello I'm testing on Postgresql 12.1 and I have a index like this: "check_dates_gist" EXCLUDE USING gist (id_test1 WITH =, id_test2 WITH =, tsrange(valid_from::timestamp without time zone, valid_to::timestamp without time zone) WITH &&) When I run this query: "select pc.relname, pi.indisuni