Re: python install defies all efforts and leaves programmer a broken shell of a man

On 05/11/2016 11:43 AM, Michael Moore wrote:

I followed your instructions and got python2 running. I was hoping for
python3, but python2 should be just fine to learn on . Thanks for your help.

Out of curiosity was that with the EDB installer or the BigSQL one?

On Tue, May 10, 2016 at 5:07 PM, Adrian Klaver
<adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:

    On 05/10/2016 04:51 PM, Michael Moore wrote:


        On Tue, May 10, 2016 at 4:30 PM, Adrian Klaver
        <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
        <mailto:adrian.klaver@aklaver.com

        <mailto:adrian.klaver@aklaver.com>>> wrote:

            On 05/10/2016 04:25 PM, Michael Moore wrote:

                I think I've tried every combination of postgres 9.4 and 9.5
                and psycopg2 and python. I've used Dependency Walker to
        examine
                dlls and
                read countless web pages. My current error is "ERROR:
        could not
                load
                library "C:/Program
        Files/PostgreSQL/9.4/lib/plpython3.dll": The
                specified procedure could not be found." Many people have
                encountered
                this error and there seems to be no shortage of
        "solutions". So my
                question is, does anybody have a clean set of
        instructions on
                how to get
                python working on a windows install of postgres; any
        version. I'm
                flexible, I can start fresh, I don't care which versions, I
                don't care
                if it's 32 bit or 64 bit. I just want to try it out.


            How did you install Postgres and from what source?

            Where and when are you getting the error message?


                Thanks,
                Mike



            --
            Adrian Klaver
            adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

        <mailto:adrian.klaver@aklaver.com

        <mailto:adrian.klaver@aklaver.com>>


        Hi, I installed postgres from http://www.postgresql.org/ . I have
        version 94 and 95 installed and running on my windows 7 machine
        in 64
        bit. I use pgAdmin and these installs are  running with no
        problems. I
        get the aforementioned error message when  I execute: "
        CREATE EXTENSION plpython3u
          SCHEMA pg_catalog
          VERSION "1.0";'

        Also when I try "CREATE PROCEDURAL LANGUAGE 'plpython3u', same
        result.Dependency walker shows a dependency on PYTHON33.DLL and
        there is
        no such file as that either in /lib or /bin. So, according to
        various
        "solution", I should be able to download this missing DLL . I've not
        done this yet because 1) it seems suspicious that a DLL is
        missing from
        the install and 2) I don't tend to trust sites that offer free DLLs.
        Virus city.


    Do not play in Windows much, but I believe you have to use the
    StackBuilder that is installed along with with the database. Select
    it and then look for the Language Pack section.

    Another, recently announced option(though it means uninstalling your
    current cluster, I believe):

    http://www.postgresql.org/message-id/CAKq0gv+Gc0i8j=ktQSkMkLJmmTqUHAm=Eza7zLv+MdXCB6H+Bw@mail.gmail.com

    http://www.bigsql.org/

    I have not tried the above yet, so I can offer no practical advice.
    Also Python is at 2.7.11(http://www.bigsql.org/components.jsp).



        Mike




    --
    Adrian Klaver

    adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com