Thanks !
Cheers,
Rémi-C
2016-03-05 0:38 GMT+01:00 Adrian Klaver :
> On 03/04/2016 01:46 AM, Rémi Cura wrote:
>
>> Thanks for the answer guys.
>>
>> I should have mentionned that I had read the doc,
>> and was looking for non explicit knowledge,
>> like :
>> - what is the reputation of plpython fo
On 03/04/2016 01:46 AM, Rémi Cura wrote:
Thanks for the answer guys.
I should have mentionned that I had read the doc,
and was looking for non explicit knowledge,
like :
- what is the reputation of plpython for a dba?
- are there actual production system that use it
- what would be the recommend
On 4 March 2016 at 10:46, Rémi Cura wrote:
> Thanks for the answer guys.
>
> I should have mentionned that I had read the doc,
> and was looking for non explicit knowledge,
> like :
> - what is the reputation of plpython for a dba?
>
Dunno.
- are there actual production system that use it
>
I
Thanks for the answer guys.
I should have mentionned that I had read the doc,
and was looking for non explicit knowledge,
like :
- what is the reputation of plpython for a dba?
- are there actual production system that use it
- what would be the recommended usage perimeter ?
(only administration
On Thu, Mar 3, 2016 at 12:35 PM, Adrian Klaver
wrote:
> On 03/03/2016 10:09 AM, Rémi Cura wrote:
>
>> Hey List,
>>
>> would it be considered safe to use plpythonu for a production database?
>> What would be the limitations/ dangers?
>>
>
> They are explained here:
>
> http://www.postgresql.org/do
On 03/03/2016 10:09 AM, Rémi Cura wrote:
Hey List,
would it be considered safe to use plpythonu for a production database?
What would be the limitations/ dangers?
They are explained here:
http://www.postgresql.org/docs/9.5/interactive/plpython.html
"PL/Python is only available as an "untrust
Hey List,
would it be considered safe to use plpythonu for a production database?
What would be the limitations/ dangers?
Thanks,
Cheers,
Rémi-C
I found the bug and it has been reported. Bug #5842.
Details here:
http://archives.postgresql.org/pgsql-bugs/2011-01/msg00134.php
Dan Popowich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
Alex Hunsaker writes:
> FYI if I don't use a slice copy here I can't get it to leak. ( find my
> test case at the end ) I don't know enough about python to know if
> thats a pl/python issue or python doing what its told-- having never
> really wrote any python myself.
>
> ---
> -- le
On Fri, Jan 14, 2011 at 19:14, Daniel Popowich wrote:
[ snip ]
> CREATE FUNCTION pygaps(start_ts timestamp without time zone, end_ts timestamp
> without time zone, gap_length interval) RETURNS SETOF timerange
> LANGUAGE plpythonu
> AS $$
>
> # because pg passes date/time to python as st
I am working with very large sets of time-series data. Imagine a
table with a timestamp as the primary key. One question I need to ask
of my data is: Are there gaps of time greater than some interval
between consecutive rows?
I wrote a function in plpgsql to answer this question and it worked
g
As an example of a filesystem access that is transaction dependent:
When I create a new supplier in the database, I need a set of
directories built on the file system.
If the directories are not there, it will cause a lot of problems when
dealing with this supplier.
When creating the supplier, I us
>> Is there any good reason not to include this functionality directly in
>> the database? (Too much parallel processing, engine not equipped for
>> that kind of processing, threading issues...)
>>
>>
> there are some issues still
>
> * missing integrated scheduler
> * missing autonomous tran
On 6/1/2010 11:12 AM, Szymon Guz wrote:
>
>
> 2010/6/1 Sim Zacks mailto:s...@compulab.co.il>>
>
> PG 8.2
>
> I am using plpythonu to add application server functionality to my
> postgresql database.
>
> For example, I have triggers and functions that FTP files, sends
> email,
2010/6/1 Sim Zacks :
> PG 8.2
>
> I am using plpythonu to add application server functionality to my
> postgresql database.
>
> For example, I have triggers and functions that FTP files, sends email,
> processes files, etc..
>
>
> Is there any good reason not to include this functionality directly
2010/6/1 Sim Zacks
> PG 8.2
>
> I am using plpythonu to add application server functionality to my
> postgresql database.
>
> For example, I have triggers and functions that FTP files, sends email,
> processes files, etc..
>
>
> Is there any good reason not to include this functionality directly
PG 8.2
I am using plpythonu to add application server functionality to my
postgresql database.
For example, I have triggers and functions that FTP files, sends email,
processes files, etc..
Is there any good reason not to include this functionality directly in
the database? (Too much parallel p
Sim Zacks wrote:
> I'm a fan of unsecured languages in the database.
> Obviously they should only be used by people who understand the difference.
> I wouldn't want python locked down.
> That would prevent so many different external functions that can now
> be integrated into the database.
>
> Amon
I'm a fan of unsecured languages in the database.
Obviously they should only be used by people who understand the difference.
I wouldn't want python locked down.
That would prevent so many different external functions that can now be
integrated into the database.
Among other things that I curren
On 1/18/08, Erik Jones <[EMAIL PROTECTED]> wrote:
> On Jan 18, 2008, at 7:48 AM, Stuart Bishop wrote:
> > plpython !=3D plpythonu.
> >
> > plpython was the 'secure' sandboxed version. The Python devs gave up
> > supporting any sort of sandboxing feature in Python declaring it
> > impossib=
> > le.
On Jan 18, 2008, at 7:48 AM, Stuart Bishop wrote:
plpython !=3D plpythonu.
plpython was the 'secure' sandboxed version. The Python devs gave up
supporting any sort of sandboxing feature in Python declaring it
impossib=
le.
Someone should definitely take a look at this: http://
sayspy.blo
Alexandre da Silva wrote:
> Hello,
> someone can tell me if is secure to create external python modules and
> import them to functions/procedures/triggers to use?
Its fine as long as you trust the users with write access to your PYTHONP=
ATH.
> Another question is that I have read in some discuss
Hello,
someone can tell me if is secure to create external python modules and
import them to functions/procedures/triggers to use?
I am doing the following:
function/procedure/trigger:
CREATE OR REPLACE FUNCTION tabela_be_i_tg_fx() RETURNS trigger AS $body$
from dbfunctions.postgres.pg_trigger i
Hi all,
I just got plpythonu working under OS X, and I'm posting my HOWTO
notes here in case I (or anyone else) needs them.
The install was pretty straightforward for me once I'd Googled the
proper magic commands. I'm on OS X Tiger (10.4.10) which comes with
Python 2.3 installed by default
On Tue, 6 Mar 2007, Korin Richmond wrote:
On Tue, 6 Mar 2007, Richard Huxton wrote:
Korin Richmond wrote:
Hi,
I want to use python modules I have written in plpythonu. I can load
these modules in functions within postgres if they are installed in the
"official" python module directories (
On Tue, 6 Mar 2007, Richard Huxton wrote:
Korin Richmond wrote:
Hi,
I want to use python modules I have written in plpythonu. I can load these
modules in functions within postgres if they are installed in the
"official" python module directories (e.g. /blah/site-packages etc.)
However, I
Korin Richmond wrote:
Hi,
I want to use python modules I have written in plpythonu. I can load
these modules in functions within postgres if they are installed in the
"official" python module directories (e.g. /blah/site-packages etc.)
However, I want to use modules which are in my home fil
Hi,
I want to use python modules I have written in plpythonu. I can load these
modules in functions within postgres if they are installed in the "official"
python module directories (e.g. /blah/site-packages etc.)
However, I want to use modules which are in my home file space, but I can't
g
Anyone interested in arrays and plpython might find this interesting.
Based on the conversation below I put these functions in a library
(pg_stuff.py):
def arr2list(a):
a = a.replace("{","[").replace("}","]")
pylist = eval(a)
return pylist
def list2arr(a):
parm = `a`
parm=parm
I ran into an interesting issue trying to pass an array to a plpythonu function
(Postgresql 8.03).
When I googled the issue I found a number of people asking similar questions and they haven't found
an answer. The problem is that there is no type mapped from a postgresql array to a python list.
I'm trying to write a stored procedure in python with postgresql 7.4,
but I cannot return a record or a setof record.
I get this error:
ERROR: cannot accept a value of type record
Is possible to return a record or am I trying to do something impossible?
Thank you
signature.asc
Description:
On Monday 08 August 2005 08:02 pm, Tom Lane wrote:
> Adrian Klaver <[EMAIL PROTECTED]> writes:
> > I recently migrated a database from Postgres 7.4.1 to Postgres 8.03. The
> > only problem I have run into is that a plpythonu function that returns
> > void will not run under 8.03. The error message
Adrian Klaver <[EMAIL PROTECTED]> writes:
> I recently migrated a database from Postgres 7.4.1 to Postgres 8.03. The only
> problem I have run into is that a plpythonu function that returns void will
> not run under 8.03. The error message states that a plpython function cannot
> return void. I g
I recently migrated a database from Postgres 7.4.1 to Postgres 8.03. The only
problem I have run into is that a plpythonu function that returns void will
not run under 8.03. The error message states that a plpython function cannot
return void. I got around it by having it return text and not act
On Sat, Jul 02, 2005 at 04:49:23PM -0400, Greg Steffensen wrote:
>
> Hey, I'm trying to write some plpython procedures that read binary data from
> images on the disk and store it in bytea fields. I'm basically trying to
> write a plpython procedure that accepts a varchar and returns a bytea, wit
Hey, I'm trying to write some plpython procedures that read binary data
from images on the disk and store it in bytea fields. I'm
basically trying to write a plpython procedure that accepts a varchar
and returns a bytea, with these procedure contents:
data = "">
return data
(The actual procedure
When accessing Postgres boolean fields (in the TD
dictionaries) in plpythonu, their values are '0' or
'1'. IIRC, in PHP their values would be 't' or 'f'.
How are boolean values actually stored in Postgres?
CSN
Discover Yahoo!
Stay in touch with email, IM, photo sharing and more
On Tue, May 03, 2005 at 02:46:04PM -0700, CSN wrote:
>
> Can dollar quoting be used with plpythonu (like with plperl -
Yes, if you're using PostgreSQL 8.0 or later. Dollar quotes have
nothing to do with the function's language -- they're just another
way to quote a string.
http://www.postgresql.
Nevermind, I see dollar-quoting was added in 8.0.
--- CSN <[EMAIL PROTECTED]> wrote:
> Can dollar quoting be used with plpythonu (like with
> plperl -
>
http://www.postgresql.org/docs/8.0/interactive/plperl.html#PLPERL-FUNCS)?
> When trying to create a function I get this error:
>
> 'syntax err
Can dollar quoting be used with plpythonu (like with
plperl -
http://www.postgresql.org/docs/8.0/interactive/plperl.html#PLPERL-FUNCS)?
When trying to create a function I get this error:
'syntax error at or near "$"'
If I use single quotes, then escape all quotes and (a
lot of) backslashes in the
On Sat, Jan 22, 2005 at 12:57:37AM -0500, Tom Lane wrote:
> [EMAIL PROTECTED] (elein) writes:
> > createlang -U postgres 'plpythonu' template1
> > createlang: language installation failed: ERROR: could not load
> > library "/usr/local/pgsql74/lib/plpython.so":
> > /usr/local/pgsql74/lib/plpyth
[EMAIL PROTECTED] (elein) writes:
> createlang -U postgres 'plpythonu' template1
> createlang: language installation failed: ERROR: could not load
> library "/usr/local/pgsql74/lib/plpython.so":
> /usr/local/pgsql74/lib/plpython.so: undefined symbol: PyDict_Copy
I'd bet on a python version is
Is this on fedora or redhat linux? If so a separate rpm must be installed for
plpython to function.
If you built from source the config script must also include building python.
On Fri, Jan 21, 2005 at 10:34:51PM -0700, Michael Fuhr wrote:
> On Fri, Jan 21, 2005 at 09:16:27PM -0800, elein wr
On Fri, Jan 21, 2005 at 09:16:27PM -0800, elein wrote:
> createlang: language installation failed: ERROR: could not load
> library "/usr/local/pgsql74/lib/plpython.so":
> /usr/local/pgsql74/lib/plpython.so: undefined symbol: PyDict_Copy
What does "ldd /usr/local/pgsql74/lib/plpython.so" show?
On a 7.4 installation built --with-python...
Python installed is 2.3.4.
On createlang, I get the following error:
createlang -U postgres 'plpythonu' template1
createlang: language installation failed: ERROR: could not load
library "/usr/local/pgsql74/lib/plpython.so":
/usr/local/pgsql74/lib/
45 matches
Mail list logo
