<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Bruce,<div><br></div><div>a couple of things :</div><div><br></div><div>$PATH won't help - the only program you are using is psql, and that is running. FWIW, I would put /usr/local/pgsql-9/0/bin into your path so you don't have to type the full command every time.</div><div><br></div><div>AddGeometryColumn is a PostGIS function - if you can run </div><div><br></div><div>psql nyc</div><div><br></div><div>and from within psql try :</div><div><br></div><div>SELECT postgis_full_version();</div><div><br></div><div>that will provide a lot of information - if it works, and tells you something about postgis, put it here. I think someone else suggested looking to see if the function exists.</div><div><br></div><div>The second one is the database search_path. within the database you can have schema's, which are like subsets of the database. many people only ever use the default one (called 'public') but it is possible that you have more, or the dumped data has more. Just having a schema is no guarantee of being able to access it - you need to set search_path to whatever to access it. You can alter database nyc set search_path.</div><div><br></div><div>I think to be much more help, a reproducible example is going to be required, but they can be hard to produce, so you might need to at least provide the output of these commands from within psql:</div><div><br></div><div>\dn</div><div><br></div><div>\dt</div><div><br></div><div>SHOW search_path;</div><div><br></div><div>SELECT postgis_full_version();</div><div><br></div><div>and maybe the nyc_buildings.sql file, or the first 50 lines of it. </div><div><br></div><div>cheers</div><div><br></div><div>Ben</div><div><br></div><div><div><div>On 17/08/2011, at 11:33 PM, <a href="mailto:bac@brucecallander.com">bac@brucecallander.com</a> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Thanks to Ben Madin for advice. I removed the apostrophes from the SRID in nyc_buildings.sql (using TextEdit) and re-ran the command<div><br></div><div><div><font class="Apple-style-span" color="#2148f5">/usr/local/pgsql-9.0/bin/psql -f /Users/bacmac/nyc_buildings.sql nyc</font></div></div><div><br></div><div>Unfortunately it produced the same result:</div><div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">BEGIN</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">psql:/Users/bacmac/nyc_buildings.sql:3: NOTICE: CREATE TABLE will create implicit sequence "nyc_buildings_gid_seq" for serial column "nyc_buildings.gid"</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">psql:/Users/bacmac/nyc_buildings.sql:3: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nyc_buildings_pkey" for table "nyc_buildings"</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">CREATE TABLE</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">psql:/Users/bacmac/nyc_buildings.sql:4: ERROR: function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) does not exist</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">LINE 1: SELECT AddGeometryColumn('','nyc_buildings','the_geom',2908,...</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5"> ^</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">HINT: No function matches the given name and argument types. You might need to add explicit type casts.</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">psql:/Users/bacmac/nyc_buildings.sql:5: ERROR: current transaction is aborted, commands ignored until end of transaction block</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5">psql:/Users/bacmac/nyc_buildings.sql:6: ERROR: current transaction is aborted … and so on.</font></div></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#2148f5"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#000003">I wonder if I need to adjust $PATH so that the function AddGeometryColumn is found? Even when I change directory to </font><font class="Apple-style-span" color="#1a3bd0">/usr/local/pgsql-9.0/bin</font><font class="Apple-style-span" color="#000003"> my Mac cannot find </font><font class="Apple-style-span" color="#1a3bd0">psql</font><font class="Apple-style-span" color="#000003"> if I type that command on its own. I always have to use the full pathname</font><font class="Apple-style-span" color="#1a3bd0"> /usr/local/pgsql-9.0/bin/psql</font><span class="Apple-style-span" style="color: rgb(0, 0, 3); ">. Strange, because typing 'ls' after changing the directory brings up the complete list of files including </span><font class="Apple-style-span" color="#1a3bd0">psql</font><span class="Apple-style-span" style="color: rgb(0, 0, 3); ">.</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><font class="Apple-style-span" color="#000003"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><span class="Apple-style-span" style="color: rgb(0, 0, 3); ">Bruce Callander</span></div><div><br></div></div>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>http://postgis.refractions.net/mailman/listinfo/postgis-users<br></blockquote></div><br></div></body></html>