Ran into a weird issue with pg_dump outputting an odd definition for a
view. First, the view definition
https://gist.github.com/keithf4/24298f7327b4a27054fd
If a pg_dump -s or pg_dumpall -s for the entire database is used, it
outputs the view definition as a table with an ALTER TABLE statement
related to logical replication followed by the "_RETURN" rule later on in
the dump file. I've come to find out that this is how views are done
internally, but seeing it in the pg_dump was odd.
https://gist.github.com/keithf4/549779a468a76e5f81d6
However, if just the table (using -t) or just the schema containing the
table (using -n) is used with pg_dump, the normal view definition is output
https://gist.github.com/keithf4/24589c0a3456fc847523
Reason we ran into this is because the client has a process that splits the
full plaintext schema dump up into separate steps for some internal
processes, and the "table" format of the dump breaks it. This is the only
view in the entire database that has this issue. Below are some catalog
entries but from what I can tell, things seem normal. And restoring the
whole dump file using psql works fine and recreates it as a normal view.
We've also tried recreating the view from scratch and it still does this.
https://gist.github.com/keithf4/2026971df875584d5c0e
So, while this does not break a normal dump/restore of a database, it does
appear to be inconsistent with how a view definition is normally dumped out.
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com