All - I'm running under Win2k. I know that signals aren't totally supported
under Windows, but I've got some questions related to DBI.
In the following script, I can't seem to catch the SIG INT after a
connection to the database is made (even w/o making any queries). Without
the connect calls,
I know this is off-topic..but I am just looking for a place with good documentation
for Perl-Pg. Since for my purposes performance is key and the Pg module can give it
to me..but the documentation for it is poor at best, and I am not a C-programmer and
am an amateur at Perl at best so I need
By Pg, do you mean PostgreSQL database? The only interface that
I'm aware of for Perl to PostgreSQL is through DBI and DBD::Pg. In
terms of documentation for PostgreSQL, I'd start with the Postgresql
home page at
http://www.postgresql.org
or go to google(www.google.com) and search for
On Mon, 12 Nov 2001, Hardy Merrill wrote:
By Pg, do you mean PostgreSQL database? The only interface that
I'm aware of for Perl to PostgreSQL is through DBI and DBD::Pg. In
terms of documentation for PostgreSQL, I'd start with the Postgresql
home page at
There is(was?) a Pg interface to
Garry Taylor wrote:
Sterin, Ilya wrote:
Why would you want to do that. Don't you already have that info when
logging a user in?
Not necessarily, especially if you are in a function that is passed a
$dbh to work with, and you've no control over how the programmer makes
the connection
On Mon, 12 Nov 2001, Rudy Lippan wrote:
There is(was?) a Pg interface to perl:
http://search.cpan.org/doc/MERGL/pgsql_perl5-1.9.0/Pg.pm
Yes, it's basically just a wrapper for libpq and basically has the same
set of functions/methods.
-- Brett
Hello,
I have a stored procedure wich has an array of values as entry parameter.
Is it possible with DBI to bind an array @tab ?
For example :
$sti=$dbi-prepare(BEGIN .$PackageNameOracle..myProcedure (:1,:2,:3);
END;);
$sti-bind_param(1, $var1);
$sti-bind_param(2, @tab); ???
On Mon, Nov 12, 2001 at 06:50:14PM +0100, Benoit Rey wrote:
I have a stored procedure wich has an array of values as entry parameter.
Is it possible with DBI to bind an array @tab ?
For example :
$sti=$dbi-prepare(BEGIN .$PackageNameOracle..myProcedure (:1,:2,:3);
END;);
On Mon, Nov 12, 2001 at 06:50:14PM +0100, Benoit Rey wrote:
I have a stored procedure wich has an array of values as entry parameter.
Is it possible with DBI to bind an array @tab ?
For example :
$sti=$dbi-prepare(BEGIN .$PackageNameOracle..myProcedure (:1,:2,:3);
END;);
Has anyone gotten the DBD::Proxy server to run on Windows-NT with
threads? I am using ActivePerl, v. 5.6 and everything works fine with
--mode=single, but when trying to start up with --mode=threads, I get:
Can't call method tid on an undefined value at c:/Perl/site/lib/Net/Daemon/Log.pm
Quoting [EMAIL PROTECTED]:
Can't call method tid on an undefined value at
c:/Perl/site/lib/Net/Daemon/Log.pm line 75
Strange, Thread-self seems to return undef under ActivePerl ...
Well, please try Net::Daemon 0.36, which I have uploaded to
CPAN some minutes ago. That problem should be
With DBI 1.20 and DBD::Oracle 1.12 and ShowErrorStatement set, an invalid
column name error looks like:
error preparing query: ORA-00904: invalid column name (DBD ERROR:
OCIStmtExecute/Describe) (select foo from walls where wall_id = 1)
Needless to say this is a frustratingly unspecific
You can do this using DBD::Sybase Library and DBI as long as the SQLServer7
has most uptodate patch, without having to use Merant/ODBC solution. Though
I'm not sure how the DBD::Sybase install will go without actually having
Sybase on the box...
-Original Message-
From: Meng Yoke
Mitsuda, Alex wrote:
You can do this using DBD::Sybase Library and DBI as long as the SQLServer7
has most uptodate patch, without having to use Merant/ODBC solution. Though
I'm not sure how the DBD::Sybase install will go without actually having
Sybase on the box...
It works great as long as
Using my version of DBD::Oracle, all-whitespace bind values seem to become
NULL:
# The following inserts ' '
my $sth = $db-prepare(insert into test (a) values (' '));
$sth-execute();
# The following inserts NULL
my $sth = $db-prepare(insert into test (a) values (?));
Thanks for the suggestions, but here's my 2 cents on DBI/DBD::Pg:.
I would LOVE to use DBD::Pg...I have written a lot of code using
DBD::Pg...however...unless there is a Monumental Performance increase between DBD::Pg
that was out with DBI-1.16, and the current version..I don't think I can
I think you are doing something wrong. DBD::Pg is fast-to-unnoticeable.
I bet that with PHP you do your operations within one transaction (do an
explicit BEGIN or whatever way in PHP you start a transaction), whereas in
perl, you don't do $dbh-{AutoCommit}=0;
The best way to kill postgres'
17 matches
Mail list logo