Re: pg_dump: CREATE TABLE + CREATE RULE vs. relreplident

>>>>> "Marko" == Marko Tiikkaja <marko(at)joh(dot)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)