aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/phpbb/db/extractor/postgres_extractor.php
diff options
context:
space:
mode:
authorMarc Alexander <admin@m-a-styles.de>2017-08-13 16:05:59 +0200
committerMarc Alexander <admin@m-a-styles.de>2017-08-13 16:05:59 +0200
commit7747d79e31e1456ed0e4fefe0dcca0990d424966 (patch)
treefbe085c0872af50ca4ba2c9c17eb054f4418da78 /phpBB/phpbb/db/extractor/postgres_extractor.php
parentd676ca12ab2674d87b77f591f64c3b69f7f512f3 (diff)
parent3aac61cfa74c0ca6816ddebed7e955519c11b9e2 (diff)
downloadforums-7747d79e31e1456ed0e4fefe0dcca0990d424966.tar
forums-7747d79e31e1456ed0e4fefe0dcca0990d424966.tar.gz
forums-7747d79e31e1456ed0e4fefe0dcca0990d424966.tar.bz2
forums-7747d79e31e1456ed0e4fefe0dcca0990d424966.tar.xz
forums-7747d79e31e1456ed0e4fefe0dcca0990d424966.zip
Merge pull request #4901 from id-tarzanych/ticket/15319
[ticket/15319] Add IF EXISTS to Postgres DROP SEQUENCE query
Diffstat (limited to 'phpBB/phpbb/db/extractor/postgres_extractor.php')
-rw-r--r--phpBB/phpbb/db/extractor/postgres_extractor.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/phpBB/phpbb/db/extractor/postgres_extractor.php b/phpBB/phpbb/db/extractor/postgres_extractor.php
index a98e39621c..0219d2ac8d 100644
--- a/phpBB/phpbb/db/extractor/postgres_extractor.php
+++ b/phpBB/phpbb/db/extractor/postgres_extractor.php
@@ -85,7 +85,7 @@ class postgres_extractor extends base_extractor
// We don't even care about storing the results. We already know the answer if we get rows back.
if ($this->db->sql_fetchrow($result))
{
- $sql_data .= "DROP SEQUENCE {$table_name}_seq;\n";
+ $sql_data .= "DROP SEQUENCE IF EXISTS {$table_name}_seq;\n";
$sql_data .= "CREATE SEQUENCE {$table_name}_seq;\n";
}
$this->db->sql_freeresult($result);