Inheritance diagram for ADODB_postgres64:

Public Member Functions
	ADODB_postgres64 ()
	ServerInfo ()
	IfNull ($field, $ifNull)
	pg_insert_id ($tablename, $fieldname)
	_insertid ($table, $column)
	_affectedrows ()
	BeginTrans ()
	RowLock ($tables, $where, $col='1 as adodbignore')
	CommitTrans ($ok=true)
	RollbackTrans ()
	MetaTables ($ttype=false, $showSchema=false, $mask=false)
	qstr ($s, $magic_quotes=false)
	SQLDate ($fmt, $col=false)
	UpdateBlobFile ($table, $column, $path, $where, $blobtype='BLOB')
	BlobDelete ($blob)
	GuessOID ($oid)
	BlobDecode ($blob, $maxsize=false, $hastrans=true)
	BlobEncode ($blob)
	UpdateBlob ($table, $column, $val, $where, $blobtype='BLOB')
	OffsetDate ($dayFraction, $date=false)
	MetaColumns ($table, $normalize=true)
	MetaIndexes ($table, $primary=FALSE, $owner=false)
	_connect ($str, $user='', $pwd='', $db='', $ctype=0)
	_nconnect ($argHostname, $argUsername, $argPassword, $argDatabaseName)
	_pconnect ($str, $user='', $pwd='', $db='')
	_query ($sql, $inputarr=false)
	_errconnect ()
	ErrorMsg ()
	ErrorNo ()
	_close ()
	CharMax ()
	TextMax ()
Public Attributes
	$databaseType = 'postgres64'
	$dataProvider = 'postgres'
	$hasInsertID = true
	$_resultid = false
	$concat_operator = '\|\|'
	$metaDatabasesSQL = "select datname from pg_database where datname not in ('template0','template1') order by 1"
	$metaTablesSQL
	$isoDates = true
	$sysDate = "CURRENT_DATE"
	$sysTimeStamp = "CURRENT_TIMESTAMP"
	$blobEncodeType = 'C'
	$metaColumnsSQL
	$metaColumnsSQL1
	$metaKeySQL
	$hasAffectedRows = true
	$hasLimit = false
	$true = 'TRUE'
	$false = 'FALSE'
	$fmtDate = "'Y-m-d'"
	$fmtTimeStamp = "'Y-m-d H:i:s'"
	$hasMoveFirst = true
	$hasGenID = true
	$_genIDSQL = "SELECT NEXTVAL('%s')"
	$_genSeqSQL = "CREATE SEQUENCE %s START %s"
	$_dropSeqSQL = "DROP SEQUENCE %s"
	$metaDefaultsSQL = "SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='%s' order by d.adnum"
	$random = 'random()'
	$autoRollback = true
	random function
	$uniqueIisR = true
	$_bindInputArray = false
	$disableBlobs = false

Detailed Description

Definition at line 57 of file adodb-postgres64.inc.php.

Member Function Documentation

ADODB_postgres64::_affectedrows ( )

Definition at line 166 of file adodb-postgres64.inc.php.

ADODB_postgres64::_close ( )

Definition at line 836 of file adodb-postgres64.inc.php.

ADODB_postgres64::_connect	(	$	str,
		$	user = `''`,
		$	pwd = `''`,
		$	db = `''`,
		$	ctype = `0`
	)

Definition at line 655 of file adodb-postgres64.inc.php.

References $host, $pwd, and adodb_addslashes().

Here is the call graph for this function:

ADODB_postgres64::_errconnect ( )

Definition at line 800 of file adodb-postgres64.inc.php.

ADODB_postgres64::_insertid	(	$	table,
		$	column
	)

Definition at line 156 of file adodb-postgres64.inc.php.

ADODB_postgres64::_nconnect	(	$	argHostname,
		$	argUsername,
		$	argPassword,
		$	argDatabaseName
	)

Definition at line 705 of file adodb-postgres64.inc.php.

ADODB_postgres64::_pconnect	(	$	str,
		$	user = `''`,
		$	pwd = `''`,
		$	db = `''`
	)

Definition at line 715 of file adodb-postgres64.inc.php.

References $pwd.

ADODB_postgres64::_query	(	$	sql,
		$	inputarr = `false`
	)

Reimplemented in ADODB_postgres7.

Definition at line 722 of file adodb-postgres64.inc.php.

References $sql.

ADODB_postgres64::ADODB_postgres64 ( )

Definition at line 120 of file adodb-postgres64.inc.php.

Referenced by ADODB_postgres7::ADODB_postgres7().

Here is the caller graph for this function:

ADODB_postgres64::BeginTrans ( )

Definition at line 174 of file adodb-postgres64.inc.php.

Referenced by RowLock().

Here is the caller graph for this function:

ADODB_postgres64::BlobDecode	(	$	blob,
		$	maxsize = `false`,
		$	hastrans = `true`
	)

Definition at line 407 of file adodb-postgres64.inc.php.

References GuessOID().

Here is the call graph for this function:

ADODB_postgres64::BlobDelete ( $ blob )

Definition at line 378 of file adodb-postgres64.inc.php.

References $result.

ADODB_postgres64::BlobEncode ( $ blob )

Definition at line 431 of file adodb-postgres64.inc.php.

ADODB_postgres64::CharMax ( )

Definition at line 852 of file adodb-postgres64.inc.php.

ADODB_postgres64::CommitTrans ( $ ok = true )

Definition at line 188 of file adodb-postgres64.inc.php.

References RollbackTrans().

Here is the call graph for this function:

ADODB_postgres64::ErrorMsg ( )

Definition at line 807 of file adodb-postgres64.inc.php.

ADODB_postgres64::ErrorNo ( )

Definition at line 826 of file adodb-postgres64.inc.php.

ADODB_postgres64::GuessOID ( $ oid )

Definition at line 389 of file adodb-postgres64.inc.php.

Referenced by BlobDecode().

Here is the caller graph for this function:

ADODB_postgres64::IfNull	(	$	field,
		$	ifNull
	)

Definition at line 135 of file adodb-postgres64.inc.php.

ADODB_postgres64::MetaColumns	(	$	table,
		$	normalize = `true`
	)

Reimplemented in ADODB_netezza.

Definition at line 473 of file adodb-postgres64.inc.php.

ADODB_postgres64::MetaIndexes	(	$	table,
		$	primary = `FALSE`,
		$	owner = `false`
	)

Definition at line 587 of file adodb-postgres64.inc.php.

ADODB_postgres64::MetaTables	(	$	ttype = `false`,
		$	showSchema = `false`,
		$	mask = `false`
	)

Definition at line 205 of file adodb-postgres64.inc.php.

References qstr(), and ServerInfo().

Here is the call graph for this function:

ADODB_postgres64::OffsetDate	(	$	dayFraction,
		$	date = `false`
	)

Definition at line 455 of file adodb-postgres64.inc.php.

ADODB_postgres64::pg_insert_id	(	$	tablename,
		$	fieldname
	)

Definition at line 141 of file adodb-postgres64.inc.php.

References $result.

ADODB_postgres64::qstr	(	$	s,
		$	magic_quotes = `false`
	)

Definition at line 238 of file adodb-postgres64.inc.php.

Referenced by MetaTables().

Here is the caller graph for this function:

ADODB_postgres64::RollbackTrans ( )

Definition at line 198 of file adodb-postgres64.inc.php.

Referenced by CommitTrans().

Here is the caller graph for this function:

ADODB_postgres64::RowLock	(	$	tables,
		$	where,
		$	col = `'1 as adodbignore'`
	)

Definition at line 181 of file adodb-postgres64.inc.php.

References BeginTrans().

Here is the call graph for this function:

ADODB_postgres64::ServerInfo ( )

Definition at line 125 of file adodb-postgres64.inc.php.

Referenced by MetaTables().

Here is the caller graph for this function:

ADODB_postgres64::SQLDate	(	$	fmt,
		$	col = `false`
	)

Definition at line 263 of file adodb-postgres64.inc.php.

ADODB_postgres64::TextMax ( )

Definition at line 860 of file adodb-postgres64.inc.php.

ADODB_postgres64::UpdateBlob	(	$	table,
		$	column,
		$	val,
		$	where,
		$	blobtype = `'BLOB'`
	)

Definition at line 445 of file adodb-postgres64.inc.php.

Referenced by UpdateBlobFile().

Here is the caller graph for this function:

ADODB_postgres64::UpdateBlobFile	(	$	table,
		$	column,
		$	path,
		$	where,
		$	blobtype = `'BLOB'`
	)

Definition at line 350 of file adodb-postgres64.inc.php.

References $rs, and UpdateBlob().

Here is the call graph for this function:

Member Data Documentation

ADODB_postgres64::$_bindInputArray = false

Definition at line 109 of file adodb-postgres64.inc.php.

ADODB_postgres64::$_dropSeqSQL = "DROP SEQUENCE %s"

Definition at line 102 of file adodb-postgres64.inc.php.

ADODB_postgres64::$_genIDSQL = "SELECT NEXTVAL('%s')"

Definition at line 100 of file adodb-postgres64.inc.php.

ADODB_postgres64::$_genSeqSQL = "CREATE SEQUENCE %s START %s"

Definition at line 101 of file adodb-postgres64.inc.php.

ADODB_postgres64::$_resultid = false

Reimplemented in ADODB_netezza.

Definition at line 61 of file adodb-postgres64.inc.php.

ADODB_postgres64::$autoRollback = true

random function

Reimplemented in ADODB_netezza.

Definition at line 105 of file adodb-postgres64.inc.php.

ADODB_postgres64::$blobEncodeType = 'C'

Reimplemented in ADODB_netezza.

Definition at line 73 of file adodb-postgres64.inc.php.

ADODB_postgres64::$concat_operator = '||'

Reimplemented in ADODB_netezza.

Definition at line 62 of file adodb-postgres64.inc.php.

ADODB_postgres64::$databaseType = 'postgres64'

Reimplemented in ADODB_netezza, and ADODB_postgres7.

Definition at line 58 of file adodb-postgres64.inc.php.

ADODB_postgres64::$dataProvider = 'postgres'

Reimplemented in ADODB_netezza.

Definition at line 59 of file adodb-postgres64.inc.php.

ADODB_postgres64::$disableBlobs = false

Definition at line 110 of file adodb-postgres64.inc.php.

ADODB_postgres64::$false = 'FALSE'

Reimplemented in ADODB_netezza.

Definition at line 95 of file adodb-postgres64.inc.php.

ADODB_postgres64::$fmtDate = "'Y-m-d'"

Reimplemented in ADODB_netezza.

Definition at line 96 of file adodb-postgres64.inc.php.

ADODB_postgres64::$fmtTimeStamp = "'Y-m-d H:i:s'"

Reimplemented in ADODB_netezza.

Definition at line 97 of file adodb-postgres64.inc.php.

ADODB_postgres64::$hasAffectedRows = true

Reimplemented in ADODB_netezza.

Definition at line 91 of file adodb-postgres64.inc.php.

ADODB_postgres64::$hasGenID = true

Definition at line 99 of file adodb-postgres64.inc.php.

ADODB_postgres64::$hasInsertID = true

Reimplemented in ADODB_netezza.

Definition at line 60 of file adodb-postgres64.inc.php.

ADODB_postgres64::$hasLimit = false

Reimplemented in ADODB_netezza, and ADODB_postgres7.

Definition at line 92 of file adodb-postgres64.inc.php.

ADODB_postgres64::$hasMoveFirst = true

Definition at line 98 of file adodb-postgres64.inc.php.

ADODB_postgres64::$isoDates = true

Reimplemented in ADODB_netezza.

Definition at line 70 of file adodb-postgres64.inc.php.

ADODB_postgres64::$metaColumnsSQL

Initial value:

"SELECT a.attname,t.typname,a.attlen,a.atttypmod,a.attnotnull,a.atthasdef,a.attnum 
                FROM pg_class c, pg_attribute a,pg_type t 
                WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s')) and a.attname not like '....%%'
AND a.attnum > 0 AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum"

Reimplemented in ADODB_netezza.

Definition at line 74 of file adodb-postgres64.inc.php.

ADODB_postgres64::$metaColumnsSQL1

Initial value:

"SELECT a.attname, t.typname, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, a.attnum 
FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n 
WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s'))
 and c.relnamespace=n.oid and n.nspname='%s' 
        and a.attname not like '....%%' AND a.attnum > 0 
        AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum"

Reimplemented in ADODB_netezza.

Definition at line 80 of file adodb-postgres64.inc.php.

ADODB_postgres64::$metaDatabasesSQL = "select datname from pg_database where datname not in ('template0','template1') order by 1"

Reimplemented in ADODB_netezza.

Definition at line 63 of file adodb-postgres64.inc.php.

ADODB_postgres64::$metaDefaultsSQL = "SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='%s' order by d.adnum"

Definition at line 103 of file adodb-postgres64.inc.php.

ADODB_postgres64::$metaKeySQL

Initial value:

"SELECT ic.relname AS index_name, a.attname AS column_name,i.indisunique AS unique_key, i.indisprimary AS primary_key 
        FROM pg_class bc, pg_class ic, pg_index i, pg_attribute a WHERE bc.oid = i.indrelid AND ic.oid = i.indexrelid AND (i.indkey[0] = a.attnum OR i.indkey[1] = a.attnum OR i.indkey[2] = a.attnum OR i.indkey[3] = a.attnum OR i.indkey[4] = a.attnum OR i.indkey[5] = a.attnum OR i.indkey[6] = a.attnum OR i.indkey[7] = a.attnum) AND a.attrelid = bc.oid AND bc.relname = '%s'"

Reimplemented in ADODB_netezza.

Definition at line 88 of file adodb-postgres64.inc.php.

ADODB_postgres64::$metaTablesSQL

Initial value:

"select tablename,'T' from pg_tables where tablename not like 'pg\_%'
        and tablename not in ('sql_features', 'sql_implementation_info', 'sql_languages',
         'sql_packages', 'sql_sizing', 'sql_sizing_profiles') 
        union 
        select viewname,'V' from pg_views where viewname not like 'pg\_%'"

Reimplemented in ADODB_netezza.

Definition at line 64 of file adodb-postgres64.inc.php.

ADODB_postgres64::$random = 'random()'

Reimplemented in ADODB_netezza.

Definition at line 104 of file adodb-postgres64.inc.php.

ADODB_postgres64::$sysDate = "CURRENT_DATE"

Reimplemented in ADODB_netezza.

Definition at line 71 of file adodb-postgres64.inc.php.

ADODB_postgres64::$sysTimeStamp = "CURRENT_TIMESTAMP"

Reimplemented in ADODB_netezza.

Definition at line 72 of file adodb-postgres64.inc.php.

ADODB_postgres64::$true = 'TRUE'

Reimplemented in ADODB_netezza.

Definition at line 94 of file adodb-postgres64.inc.php.

ADODB_postgres64::$uniqueIisR = true

Definition at line 108 of file adodb-postgres64.inc.php.

The documentation for this class was generated from the following file:

typo3/sysext/adodb/adodb/drivers/adodb-postgres64.inc.php

ADODB_postgres64 Class Reference

Public Member Functions

Public Attributes

Detailed Description

Member Function Documentation

Member Data Documentation