[postgis-users] Possible Better Error Message?
    David Fawcett 
    david.fawcett at gmail.com
       
    Mon Sep 27 12:36:40 PDT 2010
    
    
  
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
    
    
More information about the postgis-users
mailing list