File: phpbb/db/extractor/postgres_extractor.php
Unmodified
Added
Modified
Removed
| Line 208 | Line 208 |
|---|
}
// Generate constraint clauses for CHECK constraints
|
}
// Generate constraint clauses for CHECK constraints
|
$sql_checks = "SELECT pc.conname AS index_name, pg_get_constraintdef(pc.oid)
| $sql_checks = "SELECT pc.conname AS index_name, pg_get_expr(pc.conbin, pc.conrelid) AS constraint_expr
|
FROM pg_constraint pc, pg_class bc
WHERE pc.conrelid = bc.oid
AND bc.relname = '" . $this->db->sql_escape($table_name) . "'
| FROM pg_constraint pc, pg_class bc
WHERE pc.conrelid = bc.oid
AND bc.relname = '" . $this->db->sql_escape($table_name) . "'
|
| Line 225 | Line 225 |
|---|
// Add the constraints to the sql file.
while ($row = $this->db->sql_fetchrow($result))
{
|
// Add the constraints to the sql file.
while ($row = $this->db->sql_fetchrow($result))
{
|
if (!is_null($row['consrc']))
| if (!empty($row['constraint_expr']))
|
{
|
{
|
$lines[] = ' CONSTRAINT ' . $row['index_name'] . ' CHECK ' . $row['consrc'];
| $lines[] = ' CONSTRAINT ' . $row['index_name'] . ' CHECK ' . $row['constraint_expr'];
|
}
}
$this->db->sql_freeresult($result);
| }
}
$this->db->sql_freeresult($result);
|
