DBD-PgSPI script download - DBD-PgSPI DBD-PgSPI is a Perl module which works with the DBI module to provide access to

DBD-PgSPI is a Perl module which works with the DBI module to provide access to PostgreSQL database from within pl/perl functions inside the database. PostgreSQL allows perl stored procedures to be created. This module will provide access to the PostgreSQL database from inside your stored procedure. - It exports a dbh named $pg_dbh, which you may use at any time. You can also explicitly do DBI->connect("dbi:PgSPI:internal"), but it is essentially a no-op. DBI->disconnect is also not necessary, you will be will disconnected from SPI by plperl handler, when your stored proc ends. - It requires DBD::Pg for operation. DBD::Pg is used to execute table_info(), tables(), table_attributes(), type_info_all(). (No actual access is done using it or libpq, only the queries in DBD::Pg are used, to avoid duplication of code). - It can only be used with 'untrusted' perl interpreter (since trusted interpreter will not permit modules or anything like that). 'untrusted' plperl is NOT part of latest (7.1) distribution, you must use HEAD CVS branch or patch on http://www.formenos.org/PgSPI/plperlu.diff - Large objects (BLOBs, lo_open style) are not supported, and probably won't be. - Since PostgreSQL (current version) does not support nested transactions, this driver will not let you turn off AutoCommit. - Beware of quoting. Remember, all single quotes inside stored procedure need to be doubled.

RECOMMENDED TOOLS

» database module » perl module » database tool » database » perl » module

Show Categories on Home Page script      
Show Categories on Home Page Show Categories on Home Page - modified Zoli's original contr
Price: GPL$, Rating: 10, Downloads: 0

EnsEMBL-Web-Record script 1.01     
EnsEMBL-Web-Record EnsEMBL-Web-Record is a family of modules used for managing a user's pe
Price: Other Free / Open So$, Rating: 9, Downloads: 0

DBD::Mimer script 1.00     
DBD::Mimer DBD::Mimer is a Perl5 database interface for the Mimer SQL database.
Price: Other Free / Open So$, Rating: 9, Downloads: 0

Embperl script 2.002000     
Embperl Embperl gives you the power to embed Perl code in your HTML documents and the abil
Price: Other Free / Open So$, Rating: 8, Downloads: 0

Env-PS1 script 0.05     
Env-PS1 Env-PS1 package supplies variables that are ``tied'' to environment variables like
Price: Other Free / Open So$, Rating: 8, Downloads: 0

DBD-InterBase script 0.47     
DBD-InterBase DBD-InterBase is a Perl module which works with the DBI module to provide ac
Price: Other Free / Open So$, Rating: 7, Downloads: 0

ACME-Error script 0.03     
ACME-Error ACME-Error module is a front end to Perl error styles.
Price: Other Free / Open So$, Rating: 8, Downloads: 0

Config Maker script 0.007     
Config Maker Config Maker is the main module for Config::Maker file generation library.
Price: Other Free / Open So$, Rating: 10, Downloads: 0