Hi Christopher,Adrian,Tom
Thanks for quick response finally i did the pltcl install extension activity done thanks for your support.
Regards,
Prakash.R
On Fri, Mar 29, 2019 at 3:08 AM Christopher Browne <cbbrowne@xxxxxxxxx> wrote:
--On Thu, 28 Mar 2019 at 17:11, Prakash Ramakrishnan <prakash.ramakrishnan.ap@xxxxxxxxxxx> wrote:Hi Tom,Thanks for your big help i did yum install plctl and extension below path but still am getting error please find the below details,==> psqlpsql (11.2)Type "help" for help.postgres=# \c "AIBE01PR"You are now connected to database "AIBE01PR" as user "postgres".AIBE01PR=# create extension plctl;ERROR: could not open extension control file "/usr/pgsql-11/share/extension/plctl.control": No such file or directoryAIBE01PR=#If that is cut/and/pasted, then it is crystal clear that it won't work because there's a typo.There is no such computer language as "ctl". And therefore...There is no such PostgreSQL extension as "plctl"Try "create extension pltcl;" instead.It is an absolute certainty that "create extension plctl;" WILL NOT WORK, regardless of what software you may have installed. In contrast "create extension pltcl;" may quite possibly work.Many of us don't use your Linux distribution, so can only take wild guesses as to what commands might install what RPM files that might be helpful.You almost certainly did not "yum install plctl" with much success, though conceivably "yum install pltcl" might have worked instead.When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"
Regards,
Prakash.R
Postgresql DBA
