aboutsummaryrefslogtreecommitdiffstats
path: root/Frameworks/PostgresKit/Resources
diff options
context:
space:
mode:
Diffstat (limited to 'Frameworks/PostgresKit/Resources')
-rw-r--r--Frameworks/PostgresKit/Resources/TestData.sql13
1 files changed, 9 insertions, 4 deletions
diff --git a/Frameworks/PostgresKit/Resources/TestData.sql b/Frameworks/PostgresKit/Resources/TestData.sql
index 5d946918..ebcf6309 100644
--- a/Frameworks/PostgresKit/Resources/TestData.sql
+++ b/Frameworks/PostgresKit/Resources/TestData.sql
@@ -14,7 +14,15 @@ BEGIN;
SET datestyle = 'DMY';
SET client_encoding = 'UNICODE';
-CREATE TABLE IF NOT EXISTS data_types
+IF EXISTS (
+ SELECT 1 FROM information_schema.tables
+ WHERE table_name = 'data_types'
+ AND table_type = 'BASE TABLE'
+)
+ DROP TABLE data_types;
+END
+
+CREATE TABLE data_types
(
int_field INT PRIMARY KEY NOT NULL,
smallint_field SMALLINT NOT NULL,
@@ -30,9 +38,6 @@ CREATE TABLE IF NOT EXISTS data_types
timestamptz_field TIMESTAMP WITH TIME ZONE NOT NULL
);
--- If the table existed, get rid of all it's data
-TRUNCATE TABLE data_types;
-
INSERT INTO data_types (
int_field,
smallint_field,