Failed to create Postgresql extension

I use extensions and still haven't had a problem. Now I create a new one, and when I call create an extension util; I ended up in PG 9.2:

$ create extension util; FEHLER: Syntaxfehler bei "" ZEILE 1: create a util extension;

and in PG 9.1: CREATE EXTENSION util; ERROR: syntax error at or near "create" LINE 1: CREATE EXTENSION util;

I have a utility - 1.0.sql, and even when this file is empty, I get an error. my util.control looks like this:

comment ='Hilfsfunktionen fΓΌr Updateskripte' default_version = '1.0' schema=system 

Any clues? Rolf

+4
source share
1 answer

I am sure that the server you are connecting to is neither 9.1 nor 9.2. Connect to it and run SELECT version(); for confirmation.

+8
source

Source: https://habr.com/ru/post/1495696/


All Articles