>>>>> "Marko" == Marko Tiikkaja <ma...@joh.to> writes:
Marko> Hi, Marko> My colleague Per Lejontand brought to my attention that when Marko> dumping views with circular dependencies from a postgres version Marko> older than 9.4 using a recent pg_dump, the SQL looks something Marko> 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) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers