Re: plctl extension issue postgresql 11.2

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(at)gmail(dot)com>
wrote:

>
>
> On Thu, 28 Mar 2019 at 17:11, Prakash Ramakrishnan <
> prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)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