Re: Problem with accesing Oracle from plperlu functionwhen using remote pg client.

On Tue, Mar 17, 2009 at 11:27:54AM +0100, Albe Laurenz wrote:
> Tom Lane wrote:
> > > The solution to this is to change the following line in
> > > src/backend/postmaster/postmaster.c:
> >
> > We're not going to break a bunch of other applications in order to make
> > some undocumented, unsupported Oracle thingie work (until they change
> > it...). Got another solution?
>
> Yes :^)
> Upgrade to a recent Oracle Patch Set.

OK, I'm not taking on responsibility for a *fixed* Oracle bug, so
that's what I've put in the README.Oracle :)

Cheers,
David.
>
> The problem is not a corner case, as it also affected user and machine
> names (though I have no idea who would have parentheses or equality signs
> in these) as well as programs run from directories with "bad characters"
> in the name.
>
> The problem is tracked as bug 3807408 by oracle and has been fixed in
> 9.2.0.8, 10.2.0.3 and 11.1.0.6.
> If you don't want to upgrade, you can also apply the
> One-Off Patch 3807408 which has been issued for 10.2.0.1 and 9.2.0.7
> for most UNIX platforms.
>
> I tested it with a C program named "parens (5432)" on Linux
> with Oracle 10.2.0.4, and it works fine.
>
> Yours,
> Laurenz Albe
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate