Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Iterating generator from C (PostgreSQL's

From: Hannu Krosing <hannu(at)skype(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: python-list(at)python(dot)org,"pgsql-patches(at)postgresql(dot)org" <pgsql-patches(at)postgresql(dot)org>,"pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] Iterating generator from C (PostgreSQL's
Date: 2006-05-15 22:12:10
Message-ID: 1147731131.3790.48.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Ühel kenal päeval, E, 2006-05-15 kell 17:21, kirjutas Tom Lane:
> Hannu Krosing <hannu(at)skype(dot)net> writes:
> >> Sven Suursoho wrote:
> >>> As for testing in actual pl/python build environment, we had objections from 
> >>> leading postgresql Tom Lane that even if we do test it at build time, 
> >>> a determined DBA may substitute a buggy python.so later and still crash her DB instance.
> 
> The above is a straw-man depiction of my point.

Sure ;)

> What I said was that just
> because python is up-to-date on the system where plpython is *compiled*
> does not mean it'll be up-to-date on the system where plpython is *used*.

Would running an external program at pl init time and testing for its
crash status be a good broken lib test for plpython ?

> With the increasing popularity of prebuilt packages (rpm, deb, etc),
> I think it's folly to use a build-time check for this.

I guess most packaging systems can require some minimal version of
dependencies. 

And in general newer versions are less buggy than old ones.

So i guess that some combination of build-time/run-time tests,
documentation and packager education should take care of 99% of
concerns ?

Hopefully we can just ignore the "determined DBA" failure mode and move
forward with including the patch. Or do you think that trying to hack in
the extra python frame to all/some builds to ward of potentially broken
libs would still be something to go for ?

-- 
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me:  callto:hkrosing
Get Skype for free:  http://www.skype.com

NOTICE: This communication contains privileged or other confidential
information. If you have received it in error, please advise the sender
by reply email and immediately delete the message and any attachments
without copying or disclosing the contents.


In response to

pgsql-hackers by date

Next:From: Ron MayerDate: 2006-05-15 22:37:54
Subject: Re: Compression and on-disk sorting
Previous:From: Scott MarloweDate: 2006-05-15 21:39:16
Subject: Re: does wal archiving block the current client connection?

pgsql-patches by date

Next:From: Joachim WielandDate: 2006-05-16 12:25:55
Subject: .pgpass file and unix domain sockets
Previous:From: Tom LaneDate: 2006-05-15 21:21:32
Subject: Re: [HACKERS] Iterating generator from C (PostgreSQL's pl/python RETUN

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group