diff options
author | Marc Alexander <admin@m-a-styles.de> | 2017-08-13 16:05:59 +0200 |
---|---|---|
committer | Marc Alexander <admin@m-a-styles.de> | 2017-08-13 16:05:59 +0200 |
commit | 7747d79e31e1456ed0e4fefe0dcca0990d424966 (patch) | |
tree | fbe085c0872af50ca4ba2c9c17eb054f4418da78 /phpBB/phpbb/db/extractor/postgres_extractor.php | |
parent | d676ca12ab2674d87b77f591f64c3b69f7f512f3 (diff) | |
parent | 3aac61cfa74c0ca6816ddebed7e955519c11b9e2 (diff) | |
download | forums-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.php | 2 |
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); |