Skip site navigation (1) Skip section navigation (2)

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

From: "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com>
To: "Douglas Toltzman" <doug(at)oakstreetsoftware(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3363: Unable to load a plugin/library using -c switch to the psql
Date: 2007-06-05 17:17:22
Message-ID: 65937bea0706051017p161bb75buddac444ee99bd68f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 6/5/07, Douglas Toltzman <doug(at)oakstreetsoftware(dot)com> wrote:
>
> I'm not sure about the Windows shell, but the bash shell will convert
> $libdir before handing it off to psql.
>

I am actually using MinGW, so no I am not using Windows shell but a bash
shell compiled for Windows.

Yes, it was actually the bash, interpreting the $ symbol in a special way,
hence the problem. I tried the following (notice \$ , escaping $ sign ) and
now it works...

$ psql postgres test -X -c "load '\$libdir/plugins/index_adviser.dll';"
NOTICE:  IND ADV: Loaded; PID: 4968
LOAD

Had I been using the Windows shell, I wouldn't have faced this problem :)

Thanks for the pointer....

not a bug

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
>
>
>
>


-- 
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com

17°29'34.37"N  78°30'59.76"E - Hyderabad *
18°32'57.25"N  73°56'25.42"E - Pune

Sent from my BlackLaptop device

In response to

pgsql-bugs by date

Next:From: Gurjeet SinghDate: 2007-06-05 17:22:56
Subject: Re: BUG #3363: Unable to load a plugin/library using -c switch to the psql
Previous:From: Tom LaneDate: 2007-06-05 17:16:09
Subject: Re: BUG #3363: Unable to load a plugin/library using -c switch to the psql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group