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).
Just
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 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 doesn't like
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, 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
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
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
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
[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, 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 problems.
[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, 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 JDBC
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, 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.
DBI?
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 functions
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
[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
is that
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
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
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
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 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
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::PgSPI to
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 install
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
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 the files
26 matches
Mail list logo