Updated Branches: refs/heads/develop 0e3c22b44 -> fc3441246
fix drop scripts for postgres Project: http://git-wip-us.apache.org/repos/asf/marmotta/repo Commit: http://git-wip-us.apache.org/repos/asf/marmotta/commit/fc344124 Tree: http://git-wip-us.apache.org/repos/asf/marmotta/tree/fc344124 Diff: http://git-wip-us.apache.org/repos/asf/marmotta/diff/fc344124 Branch: refs/heads/develop Commit: fc34412460137d51253ab63884a70d018844828c Parents: 0e3c22b Author: Sebastian Schaffert <[email protected]> Authored: Thu Dec 19 11:56:25 2013 +0100 Committer: Sebastian Schaffert <[email protected]> Committed: Thu Dec 19 11:56:25 2013 +0100 ---------------------------------------------------------------------- .../persistence/pgsql/drop_reasoner_tables.sql | 10 +++++----- .../kiwi/persistence/pgsql/drop_base_tables.sql | 20 ++++++++++---------- .../pgsql/drop_versioning_tables.sql | 10 +++++----- 3 files changed, 20 insertions(+), 20 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/marmotta/blob/fc344124/libraries/kiwi/kiwi-reasoner/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_reasoner_tables.sql ---------------------------------------------------------------------- diff --git a/libraries/kiwi/kiwi-reasoner/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_reasoner_tables.sql b/libraries/kiwi/kiwi-reasoner/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_reasoner_tables.sql index 9f03893..63a8f2e 100644 --- a/libraries/kiwi/kiwi-reasoner/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_reasoner_tables.sql +++ b/libraries/kiwi/kiwi-reasoner/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_reasoner_tables.sql @@ -12,11 +12,11 @@ -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -- See the License for the specific language governing permissions and -- limitations under the License. -DROP INDEX idx_justification_triple; -DROP INDEX idx_just_supp_rules_just; -DROP INDEX idx_just_supp_rules_rule; -DROP INDEX idx_just_supp_triples_just; -DROP INDEX idx_just_supp_triples_triple; +DROP INDEX IF EXISTS idx_justification_triple; +DROP INDEX IF EXISTS idx_just_supp_rules_just; +DROP INDEX IF EXISTS idx_just_supp_rules_rule; +DROP INDEX IF EXISTS idx_just_supp_triples_just; +DROP INDEX IF EXISTS idx_just_supp_triples_triple; DROP TABLE IF EXISTS reasoner_just_supp_rules; DROP TABLE IF EXISTS reasoner_just_supp_triples; http://git-wip-us.apache.org/repos/asf/marmotta/blob/fc344124/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_base_tables.sql ---------------------------------------------------------------------- diff --git a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_base_tables.sql b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_base_tables.sql index 7b51e3d..267cae2 100644 --- a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_base_tables.sql +++ b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_base_tables.sql @@ -12,19 +12,19 @@ -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -- See the License for the specific language governing permissions and -- limitations under the License. -DROP INDEX idx_node_content; -DROP INDEX idx_literal_lang; +DROP INDEX IF EXISTS idx_node_content; +DROP INDEX IF EXISTS idx_literal_lang; -DROP INDEX idx_triples_p; -DROP INDEX idx_triples_spo; -DROP INDEX idx_triples_cspo; +DROP INDEX IF EXISTS idx_triples_p; +DROP INDEX IF EXISTS idx_triples_spo; +DROP INDEX IF EXISTS idx_triples_cspo; -DROP INDEX idx_namespaces_uri; -DROP INDEX idx_namespaces_prefix; +DROP INDEX IF EXISTS idx_namespaces_uri; +DROP INDEX IF EXISTS idx_namespaces_prefix; -DROP INDEX idx_reg_triple; -DROP INDEX idx_reg_key; -DROP INDEX idx_reg_tx; +DROP INDEX IF EXISTS idx_reg_triple; +DROP INDEX IF EXISTS idx_reg_key; +DROP INDEX IF EXISTS idx_reg_tx; DROP TABLE IF EXISTS triples; DROP TABLE IF EXISTS namespaces; http://git-wip-us.apache.org/repos/asf/marmotta/blob/fc344124/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_versioning_tables.sql ---------------------------------------------------------------------- diff --git a/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_versioning_tables.sql b/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_versioning_tables.sql index 68ef79a..1037e3f 100644 --- a/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_versioning_tables.sql +++ b/libraries/kiwi/kiwi-versioning/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/drop_versioning_tables.sql @@ -12,11 +12,11 @@ -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -- See the License for the specific language governing permissions and -- limitations under the License. -DROP INDEX idx_versions_added; -DROP INDEX idx_versions_removed; -DROP INDEX idx_versions_added_tid; -DROP INDEX idx_versions_removed_tid; -DROP INDEX idx_versions_created; +DROP INDEX IF EXISTS idx_versions_added; +DROP INDEX IF EXISTS idx_versions_removed; +DROP INDEX IF EXISTS idx_versions_added_tid; +DROP INDEX IF EXISTS idx_versions_removed_tid; +DROP INDEX IF EXISTS idx_versions_created; DROP TABLE IF EXISTS versions_added; DROP TABLE IF EXISTS versions_removed;
