[postgis-users] problem with AddGeometryCoumns

strk at refractions.net strk at refractions.net
Mon Feb 28 00:32:31 PST 2005


On Sun, Feb 27, 2005 at 12:47:32AM -0600, Kaustav Ghoshal wrote:
> I have installed postgis patch on my postgres server.I'm now facing this 
> problem when I'm trying to use the AddGeometryColumns function.
> 
> #create table test_table (grid integer);
> CREATE
> #select AddGeometryColumn('new_test','test_table','mygeom',33,0,3);
> ERROR;function 
> addgeometrycolumn("unknown","unknown","unknown",integer,integer,integer) 
> does not exist
> HINT: No function matches the given name and argument types.You may need 
> explicit type casts.
> 
> In statement:
> select AddGeometryColumn('new_test','test_table','mygeom',33,0,3);
> 
> 
> Any clues as to why I''m getting this problem?

Wrong syntax. See manual:
http://postgis.refractions.net/docs/ch06.html#id2916494

--strk;

> 
> 
> -- 
> Greetings,
> 
> Kaustav Ghoshal
> 
> Graduate Assistant Research
> Telecommunications Academy
> Texas A&M University
> www.kaustav.org
> 
> 
> _____________________________________________________________________________________________
> "UNIX is basically a simple operating system, but you have to be a genius 
> to understand the simplicity.  -Dennis Ritchie"  
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list