X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F14postgres-parser.t;h=4816eaf3d018b9c4f4dfa23bf5a80ec5a2072af5;hb=e8dfcd4b0d1ad2f77125c1f0ccec145e33b4d2a7;hp=44530c4b1ad0e12630b61be5401326d2d006319a;hpb=87615710721c29b00d25898ba7b66429936ce6f4;p=dbsrgits%2FSQL-Translator-2.0-ish.git

diff --git a/t/14postgres-parser.t b/t/14postgres-parser.t
index 44530c4..4816eaf 100644
--- a/t/14postgres-parser.t
+++ b/t/14postgres-parser.t
@@ -55,7 +55,9 @@ my $sql = q[
     alter table only t_test1 add constraint c_u1 unique (f_varchar);
 
     alter table t_test1 add constraint "c_fk2" foreign key (f_fk2)
-    references t_test2 (f_id) on update no action on delete cascade;
+    references t_test2 (f_id) match simple
+    on update no action on delete cascade deferrable;
+
 
     alter table t_test1 drop column f_dropped restrict;
 
@@ -189,7 +191,7 @@ is( $fk_ref1->reference_table, 't_test2', 'FK is to "t_test2" table' );
 
 my $f11 = shift @t1_fields;
 is( $f11->name, 'f_timestamp', 'Eleventh field is "f_timestamp"' );
-is( $f11->data_type, 'timestamp', 'Field is a timestamp' );
+is( $f11->data_type, 'timestamp with time zone', 'Field is a timestamp with time zone' );
 is( $f11->is_nullable, 1, 'Field can be null' );
 is( $f11->size, 0, 'Size is "0"' );
 is( $f11->default_value, undef, 'Default value is "undef"' );