The following bug has been logged online:

Bug reference: 2295
Logged by: tomek
Email address: tomek (AT) fullopcja (DOT) hopto.org
PostgreSQL version: 8.1.0.5309
Operating system: WIN XP
Description: MemoryContextSwitchTo missing
Details:

I was trying to install libpgxml addon with 8.1.0 distribution. Afer hours
of searching i've discovered that libxml is trying to call (or is linked) to
function MemoryContextSwitchTo witch should be in postgres.exe.

This function was in previous versions of postgres.exe (eg 8.0.3....).

Is it possible to implement-back this function in next release or rather we
should wait for new release of libpgxml?

regards
tom

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

tomek wrote:
Uh, I see MemoryContextSwitchTo in 8.1. I think the problem might be
that the function is not marked with DLLIMPORT for XP. Can someone try
that and see if it fixes it?

--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

"tomek" <tomek (AT) fullopcja (DOT) hopto.org> writes:
You need to recompile libpgxml, apparently.

It's never a good idea to try to use an add-on with a different major
version of Postgres than it was originally built for.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Bruce Momjian <pgman (AT) candle (DOT) pha.pa.us> writes:
No, the problem is it's a macro (actually inline, but effectively a
macro) in 8.1.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match