Re: creating extension including dependencies

Petr Jelinek <petr@2ndquadrant.com> writes:
> ... My main question is if we are 
> ok with SCHEMA having different behavior with CASCADE vs without 
> CASCADE. I went originally with "no" and added the DEFAULT flag to 
> SCHEMA. If the answer is "yes" then we don't need the flag (in that case 
> CASCADE acts as the flag).

Yeah, I was coming around to that position as well.  Insisting that
SCHEMA throw an error if the extension isn't relocatable makes sense
as long as only one extension is being considered, but once you say
CASCADE it seems like mostly a usability fail.  I think it's probably
OK if with CASCADE, SCHEMA is just "use if needed else ignore".

Obviously we've gotta document all this properly.
        regards, tom lane