>>>>> "Marko" == Marko Tiikkaja <marko@joh.to> writes:
Marko> Hi,
Marko> My colleague Per Lejontand brought to my attention that whenMarko> dumping views with circular dependencies from
apostgres versionMarko> older than 9.4 using a recent pg_dump, the SQL looks somethingMarko> like the following:
Marko> create table qwr();Marko> create rule "_RETURN" as on select to qwr do instead select;
I've wondered for a while whether this wouldn't have been better handled
as:
create view qwr(colnames...) as select null::type1, null::type2, ...;
/* ... */
create or replace view qwr as ...;
--
Andrew (irc:RhodiumToad)