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

On 6/5/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com> writes:
> > The following command fails:
>
> > psql postgres test -X -c "load '$libdir/plugins/index_adviser.dll';"
>
> Define "fails". I get complaints about the arguments being out of
> order, which they are ...

(this bug is solved (not a bug) ; please refer my last mail)

I am sorry, I didn't post the error messsage; here it goes.

ERROR: access to library "/plugins/index_adviser.dll" is not allowed

> Here, 'test' user (non-superuser) is trying to connect to 'postgres'
> > database, and wishes to load a plugin as the first step.
>
> If you think that -c means "run this command and then go into normal
> interactive mode", you're wrong anyway.

No, I do not wish to do that (I use the .psqlrc for that purpose); this is
the first command in a sequence of commands that I want psql to execute and
exit.

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