Thread: Perl + Python Postgresql 7.1.1 under Cygwin

Perl + Python Postgresql 7.1.1 under Cygwin

From

"Ernesto Revilla"

Date:

10 May 2001, 22:18:35

Dear everybody,

I successfully recompiled PostgresSQL unser Cygwin 1.3.1 / NT4+SP4.
Great work, everybody, really amazing.

For the Python interface to compile, I had to add the -DMS_WIN32 in the
Makefile.pre.in . If not a 'not constant type' happens in pgmodule.c line
951.  I don't know if there is a better place tu put the def. After this it
compiles and seems to work well. I used Python 2.1.

If the --with-perl is specified for ./configure, then the src/pl/plperl
didn't compile as it cannot find libperl.a which seems not to be part of
Cygwin 1.3.1, also perl5 is installed. So make (dlltool) stops with errors.
Do I need to install the perl sources?

I tried to build also the plpython so I could write my trigger functions in
Python. But the Makefile is not very adapted. I don't know how to call
dlltool, etc. I'll try to copy the tcl one and adapt it. I hope it'll help.

Again, great work and thanks for everybody to make available one of the best
open-source products in the world.

Best regards,
Erny
Spain

Re: Perl + Python Postgresql 7.1.1 under Cygwin

From

Jason Tishler

Date:

11 May 2001, 16:27:56

Erny,

On Fri, May 11, 2001 at 01:21:07AM +0200, Ernesto Revilla wrote:
> For the Python interface to compile, I had to add the -DMS_WIN32 in the
> Makefile.pre.in . If not a 'not constant type' happens in pgmodule.c line
> 951.  I don't know if there is a better place tu put the def. After this it
> compiles and seems to work well. I used Python 2.1.

While changing Cygwin Python to build its core as a DLL (like Win32
Python) to support shared extension modules, I have learned that Guido
prefers the style of the attached patch to solve the above problem.
I feel that this solution is particularly appropriate in this case
because the following:

    PglargeType
    PgType
    PgQueryType

are already being handled in the way that I am proposing for PgSourceType.

I will submit this patch to pgsql-patches for consideration.

Jason

--
Jason Tishler
Director, Software Engineering       Phone: +1 (732) 264-8770 x235
Dot Hill Systems Corp.               Fax:   +1 (732) 264-8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

Attachment

pgpy.patch