CODEWITHSUNDEEP
postgresql
Satish Sharma
Satish Sharma

Reputation: 3294

Postgresql plsh installation

I have Postgresql8.4 running on fedora machine , I have to use this function :

CREATE FUNCTION callSQLScript(scriptPath text) 
RETURNS void AS $$
    #!/bin/sh
    plsql -f scriptPath
$$ LANGUAGE plsh;

for this I have to install plsh but while installing plsh it is giving error while executing make after psql -d DBNAME -f PREFIX/share/pgplsh/createlang_pgplsh.sql

/bin/sh: line 0: .: pgplsh.la: file not found

Taken installation reference from plsh

Please Help me getting rid out of it.

Upvotes: 2

Views: 3022

Answers (1)

Craig Ringer
Craig Ringer

Reputation: 324501

Looks like this issue:

https://github.com/petere/plsh/issues/1

so you might want to grab the latest pl/sh. Of course, the latest version might not build with a server as old as 8.4.

Upvotes: 1

Related Questions