CODEWITHSUNDEEP
postgresql
user1423449
user1423449

Reputation: 51

Postgresql create extension fails

I'm using extensions and had no problems so far. Now I create a new one, and when I call create extension util; I get in PG 9.2:

$ create extension util; FEHLER: Syntaxfehler bei »« ZEILE 1: create extension util;

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

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

comment ='Hilfsfunktionen für Updateskripte'
default_version = '1.0'
schema=system

Any hints ? Rolf

Upvotes: 4

Views: 5903

Answers (1)

theory
theory

Reputation: 9897

I'm pretty sure that the server you're connecting to is neither 9.1 nor 9.2. Connect to it and run SELECT version(); to confirm.

Upvotes: 8

Related Questions