On Mon, 6 Dec 2004, Tom Lane wrote:
> Sure. But you don't run your middleware as root (I hope ;-)) and you
> shouldn't run it in untrusted server-side languages either. I agree
Actually - I don't practically care, and in fact I'm doing things that are
unsafe...But, I agree, others may think dif
[EMAIL PROTECTED] writes:
> On Mon, 6 Dec 2004, Andrew Dunstan wrote:
>>> . how to turn it on for trusted plperl
>> [ snip ]
> Errr my bad. I keep confusing trusted/untrusted. It does not allow it, nor
> should it.
> The purpose of PgSPI is to write 'middleware' solutions in perl - the idea
> i
Michael Fuhr wrote:
DBI? yes, $pg_dbh->quote('foo')
Yeah, I know about DBI, but since we currently can't use it in
trusted code I was wondering what we *could* use. With DBI I'd be
using placeholders wherever possible, but unless I've missed something
spi_exec_query() requires values to be i
On Mon, Dec 06, 2004 at 03:02:45PM -0500, [EMAIL PROTECTED] wrote:
> On Mon, 6 Dec 2004, Michael Fuhr wrote:
>
> > On Mon, Dec 06, 2004 at 02:34:33PM -0500, [EMAIL PROTECTED] wrote:
> > >
> > > For quick access from trusted code, spi_exec should just do fine.
> >
> > BTW, does stock PL/Perl have
On Mon, 6 Dec 2004, Michael Fuhr wrote:
> On Mon, Dec 06, 2004 at 02:34:33PM -0500, [EMAIL PROTECTED] wrote:
> >
> > For quick access from trusted code, spi_exec should just do fine.
>
> BTW, does stock PL/Perl have functions for escaping identifiers,
> strings, and binary strings?
non-DBI? no.
On Mon, Dec 06, 2004 at 02:34:33PM -0500, [EMAIL PROTECTED] wrote:
>
> For quick access from trusted code, spi_exec should just do fine.
BTW, does stock PL/Perl have functions for escaping identifiers,
strings, and binary strings?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---
On Mon, 6 Dec 2004, Andrew Dunstan wrote:
> I disagree. The crucial difference is that DBD::Pg is a client side
> library and plperl is not.
>
> I would like all perl programmers to be able to use the same (or
> similar) idioms on both the client side and the server side. (Just as
> one can use J
[EMAIL PROTECTED] wrote:
. DBD::PgSPI is covered by GPL, which means it can't be used in the core
distribution of postgres - we'd have to reinvent it in a clean room fashion.
Actually, its both GPL and Artistic license - identical to DBD::Pg (where
most of the code is taken from).
I don't
On Mon, 6 Dec 2004, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > On Mon, 6 Dec 2004, Andrew Dunstan wrote:
> >> . how to turn it on for trusted plperl
>
> > Eh, you don't turn it on. You install the package and it works ;)
>
> Really? If the plperl Safe opmask allows that, we've got some pro
[EMAIL PROTECTED] writes:
> On Mon, 6 Dec 2004, Andrew Dunstan wrote:
>> . how to turn it on for trusted plperl
> Eh, you don't turn it on. You install the package and it works ;)
Really? If the plperl Safe opmask allows that, we've got some problems.
regards, tom lane
On Mon, Dec 06, 2004 at 11:44:20AM -0700, Michael Fuhr wrote:
>
> After correcting the path (no directory) I downloaded this and it
> built without changes on FreeBSD 4.10-STABLE and Solaris 9, both
> running PostgreSQL 8.0.0rc1 and Perl 5.8.6. However, something
> changed since 0.02 that broke q
On Mon, 6 Dec 2004, Andrew Dunstan wrote:
> BTW, I would like to get these capabilities into core plperl.
There is already spi_exec_query in pl/perl for quick and dirty DB access
for this purpose, no?
> There are some obstacles to overcome. For example:
>
> . not every perl installation has DBI
BTW, I would like to get these capabilities into core plperl.
There are some obstacles to overcome. For example:
. not every perl installation has DBI
. how to turn it on for trusted plperl
. DBD::PgSPI is covered by GPL, which means it can't be used in the core
distribution of postgres - we'd hav
On Mon, Dec 06, 2004 at 08:17:29AM -0500, [EMAIL PROTECTED] wrote:
> I put a version of code with a bit more fixes from comments onlist to
> www.pilosoft.com/PgSPI/DBD-PgSPI-0.03pre.tar.gz
After correcting the path (no directory) I downloaded this and it
built without changes on FreeBSD 4.10-STA
On Mon, 6 Dec 2004, Mike Rylander wrote:
> With v. 0.01 the statement just doesn't seem to execute. I know that's
> odd, because it's supposed to be doing a prepare/execute internally, but
> nothing happens.
Wierd - the testsuite (make test) has some 'dos' in the code and it works
(and it checks
On Mon, 6 Dec 2004 08:17:29 -0500 (EST), [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> On Mon, 6 Dec 2004, Mike Rylander wrote:
>
> > Just so that you have some info, I've been using DBD::PgSPI with Pg 8.0
> > since beta 1. The only restriction I've run into with the old code is
> > that it does
On Mon, 6 Dec 2004, Mike Rylander wrote:
> Just so that you have some info, I've been using DBD::PgSPI with Pg 8.0
> since beta 1. The only restriction I've run into with the old code is
> that it doesn't like the DBD 'do' method. I have to use execute/fetchX
> or selectX, but other than that it
On Mon, 6 Dec 2004 00:27:18 -0500 (EST), [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Hello,
>
> A short note that I've updated DBD::PgSPI version 0.02 to CPAN.
>
> There are no new features - but the code now expects (and works with)
> reasonably decent versions of perl (5.8.x) and pgsql (8.x)
On Mon, Dec 06, 2004 at 02:16:19AM -0500, [EMAIL PROTECTED] wrote:
> On Sun, 5 Dec 2004, Michael Fuhr wrote:
>
> > 1. Add -I$POSTGRES_HOME/include/server to Makefile.PL. Otherwise the
> > build fails with:
>
> On second thought: Apparently that if I do 'make install-all-headers' I
> would get th
On Mon, Dec 06, 2004 at 02:10:07AM -0500, [EMAIL PROTECTED] wrote:
> On Sun, 5 Dec 2004, Michael Fuhr wrote:
> > Why should the module need the PostgreSQL source code? It builds
> > fine using the headers under the PostgreSQL install directory (e.g.,
> > /usr/local/pgsql/include), at least with 8
On Sun, 5 Dec 2004, Michael Fuhr wrote:
> 1. Add -I$POSTGRES_HOME/include/server to Makefile.PL. Otherwise the
> build fails with:
On second thought: Apparently that if I do 'make install-all-headers' I
would get the files I need in include/server. I didn't know this - make
install won't instal
On Sun, 5 Dec 2004, Michael Fuhr wrote:
> On Mon, Dec 06, 2004 at 01:38:27AM -0500, [EMAIL PROTECTED] wrote:
> > On Sun, 5 Dec 2004, Michael Fuhr wrote:
> >
> > > Using PostgreSQL 8.0.0rc1 and Perl 5.8.6 on FreeBSD 4.10-STABLE and
> > > Solaris 9, I had to make a couple of changes to get DBD::PgS
On Mon, Dec 06, 2004 at 01:38:27AM -0500, [EMAIL PROTECTED] wrote:
> On Sun, 5 Dec 2004, Michael Fuhr wrote:
>
> > Using PostgreSQL 8.0.0rc1 and Perl 5.8.6 on FreeBSD 4.10-STABLE and
> > Solaris 9, I had to make a couple of changes to get DBD::PgSPI to
> > build:
> >
> > 1. Add -I$POSTGRES_HOME/i
On Sun, 5 Dec 2004, Michael Fuhr wrote:
> Using PostgreSQL 8.0.0rc1 and Perl 5.8.6 on FreeBSD 4.10-STABLE and
> Solaris 9, I had to make a couple of changes to get DBD::PgSPI to
> build:
>
> 1. Add -I$POSTGRES_HOME/include/server to Makefile.PL. Otherwise
> the build fails with:
You should point
On Mon, Dec 06, 2004 at 12:27:18AM -0500, [EMAIL PROTECTED] wrote:
> A short note that I've updated DBD::PgSPI version 0.02 to CPAN.
>
> There are no new features - but the code now expects (and works with)
> reasonably decent versions of perl (5.8.x) and pgsql (8.x).
Using PostgreSQL 8.0.0rc1
Hello,
A short note that I've updated DBD::PgSPI version 0.02 to CPAN.
There are no new features - but the code now expects (and works with)
reasonably decent versions of perl (5.8.x) and pgsql (8.x).
No warranty is given, this code compiles and 'scratches my itch'. If it
happens to scratch y
26 matches
Mail list logo
