Re: BUG #3363: Unable to load a plugin/library using -c switch to the psql

I've not done what you're doing, so this is just a suggestion. I'm
not sure about the Windows shell, but the bash shell will convert
$libdir before handing it off to psql. Is it possible that $libdir
has a different meaning in psql than it does to the shell?

On Jun 5, 2007, at 4:20 PM, Gurjeet Singh wrote:

>
> The following bug has been logged online:
>
> Bug reference: 3363
> Logged by: Gurjeet Singh
> Email address: singh(dot)gurjeet(at)gmail(dot)com
> PostgreSQL version: 8.3devel
> Operating system: Windows
> Description: Unable to load a plugin/library using -c switch
> to the
> psql
> Details:
>
> The following command fails:
>
> psql postgres test -X -c "load '$libdir/plugins/index_adviser.dll';"
>
> Here, 'test' user (non-superuser) is trying to connect to
> 'postgres'
> database, and wishes to load a plugin as the first step.
>
> But if the same 'load' command is fired by the same user after
> log-in
> using psql, then the command succeeds.
>
> postgres=> load '$libdir/plugins/index_adviser.dll';
> NOTICE: IND ADV: Loaded; PID: 1164
> LOAD
> postgres=>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

Douglas Toltzman
doug(at)oakstreetsoftware(dot)com
(910) 526-5938