>>>>> "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

Reply via email to