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 <cbbro...@gmail.com> wrote: > > > On Thu, 28 Mar 2019 at 17:11, Prakash Ramakrishnan < > prakash.ramakrishnan...@nielsen.com> 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, >> >> ==> psql >> psql (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 directory* >> *AIBE01PR=#* >> > > 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
