[postgis-devel] Valid SRIDs

[Tom Lane]

Stephen Frost <sfrost at snowman.net> writes:
> I just don't see any way that during a restore we could ensure that
> things work in a situation where the user-defined typmod functions are
> checking the spatial_ref_sys table to ensure the srid being added is
> valid.  The only thing I'm coming up with would involve another GUC
> which would have to be set at the start of the dump as, basically,
> "don't check the srid", with it defaulting to "check" for normal
> operations.  I'm not sure there's even a way for an add-on module like
> PostGIS to add a GUC though, and I don't see enough justification to
> even try to have a 'generic'/module-agnostic GUC added to core to
> support this.

It is possible for an add-on to define its own GUC variable, but the
hard part would be getting consensus for pg_dump to emit commands to
set a variable that might not exist.  There are lots of usage modes
in which errors during restore aren't acceptable, even though they
might be "harmless".

			regards, tom lane