[postgis-users] Possible Better Error Message?

[David Fawcett]

Thanks Leo,

I assumed that there was a good reason for the not-so-good error messages.

David.

On Mon, Sep 27, 2010 at 2:45 PM, Paragon Corporation <lr at pcorp.us> wrote:
> David,
>
> What you are asking I don't think is doable.
>
> Short-Answer - your query never hits PostGIS land to be caught.
>
> Longer answer:
>
> The error you get below is a PostgreSQL error and that is because it doesn't
> know which function to send the request to.  Since PostgreSQL functions are
> overloaded, unlike some other databases,  the name of a function is not
> sufficient to look up a function.
>
> Leo
> http://www.postgis.us
>
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of David
> Fawcett
> Sent: Monday, September 27, 2010 3:37 PM
> To: PostGIS Users Discussion
> Subject: [postgis-users] Possible Better Error Message?
>
> I have a question about error messages.  I was attempting to use
> ST_SetSRID() and the error message that I got definitely pointed me in the
> wrong direction (see below).
>
> The problem was that I was omitting the second arg.
>
> It would be great if this case threw an error that said something like,
> 'incorrect number of arguments, ST_SetSRID(geometry, srid) requires two
> arguments'.
>
> I have no idea how the error messages are implemented, so I don't know if
> this is a reasonable suggestion/request.  I am willing to file a ticket if
> it would be useful.
>
> David.
>
>
> ERROR:  function st_setsrid(geometry) does not exist LINE 1: SELECT qid,
> st_distance(ST_Centroid(the_geom), ST_Setsrid(ST...
>                                                       ^
> HINT:  No function matches the given name and argument types. You might need
> to add explicit type casts.
>
>
> ********** Error **********
>
> ERROR: function st_setsrid(geometry) does not exist SQL state: 42883
> Hint: No function matches the given name and argument types. You might need
> to add explicit type casts.
> Character: 48
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>