Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 29 Jan 2008 18:36:02 -0800 Reece Hart <[EMAIL PROTECTED]> wrote: > I'm guessing lack of maintenance... the SFPUG hasn't maintained David > for a very long time. We think he lives at Casa Donde, but no one is > really sure where that is. I th

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Reece Hart
On Tue, 2008-01-29 at 13:28 -0500, Geoffrey wrote: > Are you speaking from personal experience, or just of the lack of > maintenance? I'm guessing lack of maintenance... the SFPUG hasn't maintained David for a very long time. We think he lives at Casa Donde, but no one is really sure where that

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Andrew Sullivan
On Tue, Jan 29, 2008 at 03:16:41PM -0500, A.M. wrote: > ...and Pg.pm includes a serious security hole in the form of non- > existent query escaping which will never be fixed. Are we really > discussing the semantics of "rust"? It has never done that escaping. No rust has occurred. This is a

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread A.M.
On Jan 29, 2008, at 2:36 PM, Andrew Sullivan wrote: On Tue, Jan 29, 2008 at 01:56:35PM -0500, A.M. wrote: The postgresql from eight years ago is also quite rusty. No, it's not, which is my point. If you don't need any of the features you mention, and are aware of the limitations, there's

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Andrew Sullivan
On Tue, Jan 29, 2008 at 01:56:35PM -0500, A.M. wrote: > The postgresql from eight years ago is also quite rusty. No, it's not, which is my point. If you don't need any of the features you mention, and are aware of the limitations, there's nothing wrong with using it. The v2 protocol works, for i

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread A.M.
On Jan 29, 2008, at 1:07 PM, Andrew Sullivan wrote: On Tue, Jan 29, 2008 at 08:14:28AM -0800, David Fetter wrote: I wouldn't trust that library or anything that depends on it if I were you. It's been unmaintained for a *very* long time. Because code rusts when it's sitting around on a h

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Vivek Khera
On Jan 29, 2008, at 7:24 AM, Glyn Astill wrote: I'm trying yo run a perl script that uses DBI (Slonys psql_replication_check.pl to be precise) and I'm getting the error: Can't locate Pg.pm in @INC It doesn't use DBI, it uses Pg. At some point I posted patches to convert it to DBI and DBD

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Geoffrey
David Fetter wrote: On Tue, Jan 29, 2008 at 05:10:00AM -0800, Glyn Astill wrote: well its using the pgsql_replication_check.pl, which does: -- use Pg; I wouldn't trust that library or anything that depends on it if I were you. It's been unmaintained for a *very* long time

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Andrew Sullivan
On Tue, Jan 29, 2008 at 08:14:28AM -0800, David Fetter wrote: > > I wouldn't trust that library or anything that depends on it if I were > you. It's been unmaintained for a *very* long time. Because code rusts when it's sitting around on a hard drive? Pg.pm doesn't get much attention, I agree,

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Andrew Sullivan
On Tue, Jan 29, 2008 at 04:24:05AM -0800, Glyn Astill wrote: > Hi chaps, > > I'm trying yo run a perl script that uses DBI (Slonys > psql_replication_check.pl to be precise) and I'm getting the error: > > Can't locate Pg.pm in @INC Pg.pm isn't DBI. It's the Pg Perl interface. A --

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread David Fetter
On Tue, Jan 29, 2008 at 05:10:00AM -0800, Glyn Astill wrote: > well its using the pgsql_replication_check.pl, which does: > > -- > use Pg; I wouldn't trust that library or anything that depends on it if I were you. It's been unmaintained for a *very* long time. Cheers, David

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Glyn Astill
Hi chaps, Excellent, it was libpg-perl I needed. Thanks --- Richard Huxton <[EMAIL PROTECTED]> wrote: > Glyn Astill wrote: > > well its using the pgsql_replication_check.pl, which does: > > > > -- > > use Pg; > > use Getopt::Std; > > > > > So I assume it's not getting pas

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread adam_pgsql
On 29 Jan 2008, at 13:39, Martijn van Oosterhout wrote: On Tue, Jan 29, 2008 at 01:30:04PM +, adam_pgsql wrote: this looks to be using the Pg module rather than DBI + DBD::Pg. This one i think: http://www.cpan.org/authors/id/M/ME/MERGL/pgsql_perl5-1.9.0.tar.gz i think thats quite old no

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Martijn van Oosterhout
On Tue, Jan 29, 2008 at 01:30:04PM +, adam_pgsql wrote: > > this looks to be using the Pg module rather than DBI + DBD::Pg. This > one i think: > > http://www.cpan.org/authors/id/M/ME/MERGL/pgsql_perl5-1.9.0.tar.gz > > i think thats quite old now though In the one in this package: htt

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Colin Wetherbee
Colin Wetherbee wrote: CaT wrote: On Tue, Jan 29, 2008 at 05:10:00AM -0800, Glyn Astill wrote: well its using the pgsql_replication_check.pl, which does: -- use Pg; ... So I assume it's not getting past the use Pg line as although it's looking in /usr/lib/perl5 it's not g

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Colin Wetherbee
adam_pgsql wrote: this looks to be using the Pg module rather than DBI + DBD::Pg. This one i think: http://www.cpan.org/authors/id/M/ME/MERGL/pgsql_perl5-1.9.0.tar.gz i think thats quite old now though Indeed, that's how it looks. That would be in the libpg-perl package on Debian. In

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread adam_pgsql
this looks to be using the Pg module rather than DBI + DBD::Pg. This one i think: http://www.cpan.org/authors/id/M/ME/MERGL/pgsql_perl5-1.9.0.tar.gz i think thats quite old now though On 29 Jan 2008, at 13:10, Glyn Astill wrote: well its using the pgsql_replication_check.pl, which do

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Colin Wetherbee
CaT wrote: On Tue, Jan 29, 2008 at 05:10:00AM -0800, Glyn Astill wrote: well its using the pgsql_replication_check.pl, which does: -- use Pg; ... So I assume it's not getting past the use Pg line as although it's looking in /usr/lib/perl5 it's not going to look in /usr/lib

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Richard Huxton
Glyn Astill wrote: well its using the pgsql_replication_check.pl, which does: -- use Pg; use Getopt::Std; So I assume it's not getting past the use Pg line as although it's looking in /usr/lib/perl5 it's not going to look in /usr/lib/perl5/DBD ?? DBD::Pg is not the same

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread CaT
On Tue, Jan 29, 2008 at 05:10:00AM -0800, Glyn Astill wrote: > well its using the pgsql_replication_check.pl, which does: > > -- > use Pg; ... > So I assume it's not getting past the use Pg line as although it's > looking in /usr/lib/perl5 it's not going to look in > /usr/lib/p

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Glyn Astill
well its using the pgsql_replication_check.pl, which does: -- use Pg; use Getopt::Std; our ($opt_h, $opt_d, $opt_p, $opt_U, $opt_w, $opt_c) = ''; my ($conn, $res, $status, @tuple); my $query = 'SELECT * FROM replication_status' ; my @rep_time; -

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread CaT
On Tue, Jan 29, 2008 at 04:45:48AM -0800, Glyn Astill wrote: > Should the subdirectory DBD be in there? Perl was setup using apt. How are you using it and what's your DBI db connect line? I'm about to go to sleep so if I don't reply it'll be because I'm unconcious. :) -- "To the extent that

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread Glyn Astill
> Run perl -V and see if the path is there for @INC. If it's there, > check > such things as permissions. If not, ponder deeply as to why this is > so > (as /usr/lib/perl5 is a standard path for perl in /usr) and if you > can't > fix it 'properly' you can work-around with the use of 'use lib' > (

Re: [GENERAL] OT - pg perl DBI question

2008-01-29 Thread CaT
On Tue, Jan 29, 2008 at 04:24:05AM -0800, Glyn Astill wrote: > I'm trying yo run a perl script that uses DBI (Slonys > psql_replication_check.pl to be precise) and I'm getting the error: > > Can't locate Pg.pm in @INC > > Now I do have the file in /usr/lib/perl5/DBD/ but the script can't > see it

[GENERAL] OT - pg perl DBI question

2008-01-29 Thread Glyn Astill
Hi chaps, I'm trying yo run a perl script that uses DBI (Slonys psql_replication_check.pl to be precise) and I'm getting the error: Can't locate Pg.pm in @INC Now I do have the file in /usr/lib/perl5/DBD/ but the script can't see it. I'm guessing that unless I fudge it and put the absoloute path