aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--Frameworks/PostgresKit/Resources/TestData.sql13
-rw-r--r--Frameworks/PostgresKit/Source/FLXPostgresTypes.h1
2 files changed, 10 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,
diff --git a/Frameworks/PostgresKit/Source/FLXPostgresTypes.h b/Frameworks/PostgresKit/Source/FLXPostgresTypes.h
index 5c09e5d8..039a8282 100644
--- a/Frameworks/PostgresKit/Source/FLXPostgresTypes.h
+++ b/Frameworks/PostgresKit/Source/FLXPostgresTypes.h
@@ -111,5 +111,6 @@ enum
// Numeric
FLXPostgresOidNumeric = 1700, // StringHandler => NSString
+ // UUID
FLXPostgresOidUUID = 2950 // StringHandler => NSString
};