NAME

DBIO::PostgreSQL::Introspect::OutsideReaders - Introspect the views outside the schema filter that read columns inside it

VERSION

version 0.900007

DESCRIPTION

The model is bounded by the schema filter (pg_schemas): a view in a schema outside it is not in the tables section, and the diff neither creates, drops nor re-creates it. It still holds the columns it reads, and PostgreSQL does not alter the type of a column a view uses. This section names such views, so that DBIO::PostgreSQL::Diff::Column can refuse the type change by name instead of leaving it to the server.

Without a schema filter every schema is in the model and the section is empty.

METHODS

fetch

my $readers = DBIO::PostgreSQL::Introspect::OutsideReaders->fetch($dbh, $filter);

Returns a hashref keyed by schema.view, for each view or materialized view in a schema that is not in $filter and reads a column of a relation that is. Each value has schema_name, table_name, kind (v or m) and depends_on_columns, a HashRef from the key of a relation in the filter to an ArrayRef of column names, sorted, the same shape as the one of DBIO::PostgreSQL::Introspect::Tables. Only the views that read such a column are in it, and only their direct readers: a view that stands on one of them fails with it, and is named by the server when it is dropped. System schemas and what an extension owns are left out.

AUTHOR

DBIO & DBIx::Class Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.