Thread: createlang issue in XP

Good afternoon to you all.

First of all I want to thank each one of you for the efforts you make to
provide the world with a first class Open source Database. I myself
started only recently working with PostgreSQL and I must confess that
I'm quit impressed both by the database system itself as by the
community that seems to underpin this initiative.

For the moment we have 2 XP boxes running PgSQL-8.0.3. and up until
today all our questions have been answered trough the documentation, the
manuals and the websites that are included with, or that are related to,
the PgSQL 8.0.3 distribution.

Now today I've tried to install Python as the Procedural language on one
of our XP-boxes. I've followed the instructions, as indicated in the
user manual under “createlang”, and as result I received the following
error message:

    createlang: language installation failed: ERROR: could not load
    library "C:/Program Files/
    PostgreSQL/8.0/lib/plpython.dll": dynamic load error

I've al ready found out that this issue was resolved trough a patch,
http://archives.postgresql.org/pgsql-patches/2005-08/msg00180.php, but I
didn't found a way to obtain this patch. So I've a couple of questions
for you:

    *

      can I download and install this patch in, let's just say, an
      Oracle, or even Microsoft, kind of way? I've found no indication
      whatsoever on the PgSQL web pages.

    *

      If the patch can't be downloaded and installed separately, how do
      you propose to solve this problem?


Kind regards

EradICT
Belgium - Europe

My system configuration
XP Professional (SP2)
Intel Pentium III
797 MHz, 256 MB of RAM
PgSQL – 8.0.3
PgAdmin III -1.2.1 (on the DB-server)
PgAdmin III -1.2.2 (on the clients)

Eradict <eradict@versateladsl.be> writes:
>       can I download and install this patch in, let's just say, an
>       Oracle, or even Microsoft, kind of way?

The "microsoft kind of way" is to wait for the next update release.
8.0.4 should be out pretty soon.

            regards, tom lane

Hi all:

This is my first post.

I have been working with MySQL from about one year ago. And due to some
issues about the relationship between SCO and MySQL (between other issues) I
have been wondering about the possibilities to move to Postgresql.

The question is:

Does anybody knows a good source of information of how painful is it to move
from MySQL to Postgresql, pros and cons, equivalent tools (for example,
phpmyadmin/phppgadmin), etc.

Thanks a lot and very best regards to all of you,

Alvaro.

Try http://techdocs.postgresql.org/

Mike
On Tue, 2005-10-04 at 15:46 -0500, Alvaro Cobo wrote:
> Hi all:
>
> This is my first post.
>
> I have been working with MySQL from about one year ago. And due to some
> issues about the relationship between SCO and MySQL (between other issues) I
> have been wondering about the possibilities to move to Postgresql.
>
> The question is:
>
> Does anybody knows a good source of information of how painful is it to move
> from MySQL to Postgresql, pros and cons, equivalent tools (for example,
> phpmyadmin/phppgadmin), etc.
>
> Thanks a lot and very best regards to all of you,
>
> Alvaro.
>
>
> ---------------------------(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