Alzabo::Driver::PostgreSQL(3pm) User Contributed Perl Documentation Alzabo::Driver::PostgreSQL(3pm)NAME
Alzabo::Driver::PostgreSQL - PostgreSQL specific Alzabo driver subclass
SYNOPSIS
use Alzabo::Driver::PostgreSQL;
DESCRIPTION
This provides some PostgreSQL specific implementations for the virtual methods in Alzabo::Driver.
METHODS
connect, create_database, drop_database
Besides the parameters listed in the Alzabo::Driver docs, the following parameters are accepted:
* options
* tty
schemas
This method accepts the same parameters as the "connect()" method.
get_last_id
Returns the last id created for a sequenced column.
identifier_length
Returns the maximum identifier length allowed by the database. This is really a guess based on the server version, since the actual value
is set when the server is compiled.
BUGS
In testing, I found that there were some problems using Postgres in a situation where you start the app, connect to the database, get some
data, fork, reconnect, and and then get more data. I suspect that this has more to do with the DBD::Pg driver and/or Postgres itself than
Alzabo. I don't believe this would be a problem with an app which forks before ever connecting to the database (such as mod_perl).
AUTHOR
Dave Rolsky, <autarch@urth.org>
perl v5.8.8 2007-12-23 Alzabo::Driver::PostgreSQL(3pm)
Check Out this Related Man Page
Alzabo::Create::ColumnDefinition(3pm) User Contributed Perl Documentation Alzabo::Create::ColumnDefinition(3pm)NAME
Alzabo::Create::ColumnDefinition - Column definition object for schema creation
SYNOPSIS
use Alzabo::Create::ColumnDefinition;
DESCRIPTION
This object holds information on a column that might need to be shared with another column. The reason this class exists is that if a col-
umn is a key in two or more tables, then some of the information related to that column should change automatically in multiple places
whenever it changes at all. Right now this is only type ('VARCHAR', 'NUMBER', etc) and length/precision information. This object also has
an 'owner', which is the column which created it.
INHERITS FROM
"Alzabo::ColumnDefinition"
Note: all relevant documentation from the superclass has been merged into this document.
METHODS
new
This method takes the following parameters:
* owner => "Alzabo::Create::ColumnDefinition" object
* type => $type
It returns a new "Alzabo::Create::ColumnDefinition" object.
alter
See the "Alzabo::Column->alter()" method for details.
type
Returns the object's type as a string.
set_type ($string)
Sets the object's type.
Throws: "Alzabo::Exception::Params", "Alzabo::Exception::RDBMSRules"
length
Returns the length attribute of the column, or undef if there is none.
precision
Returns the precision attribute of the column, or undef if there is none.
set_length
This method takes the following parameters:
* length => $length
* precision => $precision (optional)
Sets the column's length and precision. The precision parameter is optional (though some column types may require it if the length is
set).
Throws: "Alzabo::Exception::Params", "Alzabo::Exception::RDBMSRules"
owner
Returns the "Alzabo::Create::Column" object that owns this definitions (the column that created it).
perl v5.8.8 2007-12-23 Alzabo::Create::ColumnDefinition(3pm)
I need to connect to DB2 through Unix and check whether the database is up or not. We are planning to use Neon shadow direct to connect to the same. I would like to know how to pass parameters to neon shadow direct. Any guidance/help in this regard would be helpful.
My unix box is AIX 1.
... (3 Replies)
I looking for someone who can help me port a Linux Driver to a OpenBSD( OS X ) Unix Driver. The driver is for a Logic Controls LD9000 USB Customer Display. The currently don't have a driver for the mac operating system, but they do however have one for the Linux OS.
So, I am just trying to... (8 Replies)
I don't know if this is better suited for the application section, but here goes.
We are currently running HP-UX 11 as our database server. The database is Progress version 9.1C.
As of late, some of our batch processes that run on the UNIX db server are erroring out because of what appear to... (3 Replies)
Hi guys
I am having some SCASI Driver issue while installing the RHEL 3 on SunFire X4200 series Server so can anyone help me out as how to get rid off from this problem. (2 Replies)
I am getting sqlplus not found error while trying to connect to database from unix.
my sql plus is present at the location
/opt/dbms/app/oracle/product/10.2_Client
and i gave in shell script as below.
ORACLE_HOME=/opt/dbms/app/oracle/product/10.2_Client
export ORACLE_HOME
Please help me with... (6 Replies)
When I use SecureCRT software to connect with AIX servers, don't know why sessions always be kicked out from the SecureCRT if I don't do anything in a few minutes. I think this maybe the SecureCRT configuraiton problem, Who knows how to keep session conect even through I don't do anything?
... (3 Replies)
hi there.
in perl, I am struggling to find a simple method of connecting to a database, determining if the result of my query is "true" and then testing against the result. I dont even really want the data that i am 'SELECT'íng. i effectively just want to check that a record exists with a UID... (2 Replies)
I just bought a Lexmark PRO901 printer, for I was told that it was debian compliant.
Upon unpacking I saw mention of Ubuntu.
I thought of returning it but found a site that had
Printer Driver with JRE for 64-bit Debian Package Manager based Distros
What I downloaded was ... (1 Reply)
I'm having some troubles setting an instance of postgreSQL to automatically start upon system boot. I have two servers running this app, one is automatically starting the service, the other is not. I'm attempting to use the "svcadmin" command, however, apparently when I run a "svcs -a" search, the... (6 Replies)
I made a script to remove Postgres if this is already installed on your system. I have a other script to install Postgres, so this script can be used before you going to install Postgres.
Do you like this script? I would love to hear feedback.
#!/bin/bash
#
#################################... (2 Replies)
Hi All,
I am working on a file transfer tool between unix servers.
for this i am looking for a small database which is free and compatible with all unix OS and can be bundled in a package with other scripts.
Any suggestions (8 Replies)