Question 207611 in PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – Error while creating an extension in postgres

"postgres=# create extension addme;
ERROR: extension "addme" has no installation script nor update path for version "0.0.1"

How to resolve this error while creating an extension in postgres

How do I resolve this error and create an extension, which script to be installed and which path to be updated and How to come up with solution.

Tags:

2

Answers


  1. 0

    Your questions is pretty much self explanatory, as per the error message, the extension addme lacks the required installation or update scripts for version "0.0.1".

    For detailed instructions and to ensure compatibility with your PostgreSQL version, consult the extensions documentation of postgresql. Try generating the extension again after you have the necessary scripts and have adjusted the extension’s script or path. Make sure you use the appropriate PostgreSQL SQL command or tool, such as the CREATE EXTENSION command or pgAdmin, to create extensions. You may fix the problem and successfully add the "addme" extension to PostgreSQL by following these instructions.

    Login or Signup to reply.
  2. 0

    The error message which you are getting shows that the PostgreSQL extension "addme" is not currently stored on the system. There are two ways in which you can resolve this error:

    1. First one is that you use the CREATE EXTENSION statement. Just type in the following command:

      CREATE EXTENSION addme;

    2. The second method is that you build the extension from the source code. This would allow you to have the latest version of the extension but the downside is that this method is a bit complex. You would need to install the code from the project’s website and then build it.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search