q{
create table pg_loader_test10 (
id bigserial primary key,
- eleven_id int,
- foreign key (eleven_id) references pg_loader_test9(id)
- on delete restrict on update set null
+ nine_id int,
+ foreign key (nine_id) references pg_loader_test9(id)
+ on delete restrict on update set null deferrable
)
},
-
],
pre_drop_ddl => [
'DROP SCHEMA dbicsl_test CASCADE',
'long table comment is in DESCRIPTION';
# test on delete/update fk clause introspection
- ok ((my $rel_info = $schema->source('PgLoaderTest10')->relationship_info('eleven')),
+ ok ((my $rel_info = $schema->source('PgLoaderTest10')->relationship_info('nine')),
'got rel info');
is $rel_info->{attrs}{on_delete}, 'RESTRICT',
is $rel_info->{attrs}{on_update}, 'SET NULL',
'ON UPDATE clause introspected correctly';
- is $rel_info->{attrs}{is_deferrable}, 0,
+ is $rel_info->{attrs}{is_deferrable}, 1,
'DEFERRABLE clause introspected correctly';
foreach my $db_schema (['dbicsl-test', 'dbicsl.test'], '%') {