[postgis-users] Schema support in loader/dumper

[David Blasby]

strk wrote:
>>This sounds like a lot of work.  Perhaps we should just change all the 
>>"CREATE FUNCTION ..." clauses to "CREATE OR REPLACE FUNCTION...".  This 
>>should work well for everything but the GiST support stuff...
>>
>>dave
> 
> 
> That would not always work.
> 
> For example, if you need to change the return type:
> 
> ERROR:  ProcedureCreate: cannot change return type of existing function.
>         Use DROP FUNCTION first.
> 
> What was wrong with postgis_undef.sql again ?
> Functions oid mismatch or just an ordering issue ?
> 
> BTW: did people try using postgis_new.sql ? further changes
>      in sql files would be easier if we can support CPP generation.

I dont think doing a postgis_undef.sql is such a good idea - I believe 
it removes the actual postgis geometry type which will mean all your 
geometry data will be un-accessible (because the type OID will not 
reference anything).

I havent looked at postgis_new.sql.

dave