ERROR: Negative SRID is not for GEOGRAPHY at character 69

[strk]

Try this:

select 'POINT(0 0)'::geography(point, 0);

Should behave the same as omitting the SRID instead.

[strk]

I have some doubts about what needs to be done here, as the code has an explicit block added to check for the condition of an explicit UNKNOWN srid being given. See source:trunk/postgis/gserialized_typmod.c?rev=8615#L242​

[robe]

no it shouldn't. You can't have geography have an unknown. So geography(point) is the same as geography(point,4326)

geography(point,0) is totally illogical and no one should even be trying to doit and should get a nasty message if they do.

[strk]

I guess the sanest thing is to consider UNKNOWN as omitted, which is using the default of 4326. Done so with r8862.

Remember: 0 == omitted == UNKNOWN

We discussed about 0 being the same as omitted with geometry as well, didn't we ? When I complained about being able to do : 'SRID=4326;POINT(0 0)'::geometry(point, 0);

[robe]

Yes we did and we concluded its NOT the same.

In geometry omitted means you can have a mixed bag of geometries with various SRIDS - no SRID constraint checking is happening

where as 0 means you want it to be unknown.

[strk]

Here's the discussion I'm talking about: ticket #1235, you convinced me of the contrary.

[robe]

ah okay — I stand corrected. I forgot we decided its stupid to apply any spatial constraint to unknown.