* - keywordTableMap : Map of reserved table names to alternative table names to use
*/
public function __construct( array $params ) {
- $this->port = isset( $params['port'] ) ? $params['port'] : false;
- $this->keywordTableMap = isset( $params['keywordTableMap'] )
- ? $params['keywordTableMap']
- : [];
+ $this->port = $params['port'] ?? false;
+ $this->keywordTableMap = $params['keywordTableMap'] ?? [];
parent::__construct( $params );
}
* @return string Value of $name or remapped name if $name is a reserved keyword
*/
public function remappedTableName( $name ) {
- return isset( $this->keywordTableMap[$name] ) ? $this->keywordTableMap[$name] : $name;
+ return $this->keywordTableMap[$name] ?? $name;
}
/**
$newNameE = $this->addIdentifierQuotes( $newName );
$oldNameE = $this->addIdentifierQuotes( $oldName );
- $ret = $this->query( 'CREATE ' . ( $temporary ? 'TEMPORARY ' : '' ) . " TABLE $newNameE " .
+ $temporary = $temporary ? 'TEMPORARY' : '';
+
+ $ret = $this->query( "CREATE $temporary TABLE $newNameE " .
"(LIKE $oldNameE INCLUDING DEFAULTS INCLUDING INDEXES)", $fname );
if ( !$ret ) {
return $ret;
$fieldE = $this->addIdentifierQuotes( $field );
$newSeqE = $this->addIdentifierQuotes( $newSeq );
$newSeqQ = $this->addQuotes( $newSeq );
- $this->query( 'CREATE ' . ( $temporary ? 'TEMPORARY ' : '' ) . " SEQUENCE $newSeqE", $fname );
+ $this->query( "CREATE $temporary SEQUENCE $newSeqE OWNED BY $newNameE.$fieldE", $fname );
$this->query(
"ALTER TABLE $newNameE ALTER COLUMN $fieldE SET DEFAULT nextval({$newSeqQ}::regclass)",
$fname
}
}
+/**
+ * @deprecated since 1.29
+ */
class_alias( DatabasePostgres::class, 'DatabasePostgres' );