Bruce,
a couple of things :
$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.
AddGeometryColumn is a PostGIS function - if you can run
psql nyc
and from within psql try :
SELECT postgis_full_version();
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.
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.
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:
\dn
\dt
SHOW search_path;
SELECT postgis_full_version();
and maybe the nyc_buildings.sql file, or the first 50 lines of it.
cheers
Ben
On 17/08/2011, at 11:33 PM, b...@brucecallander.com wrote:
> Thanks to Ben Madin for advice. I removed the apostrophes from the SRID in
> nyc_buildings.sql (using TextEdit) and re-ran the command
>
> /usr/local/pgsql-9.0/bin/psql -f /Users/bacmac/nyc_buildings.sql nyc
>
> Unfortunately it produced the same result:
>
> BEGIN
> psql:/Users/bacmac/nyc_buildings.sql:3: NOTICE: CREATE TABLE will create
> implicit sequence "nyc_buildings_gid_seq" for serial column
> "nyc_buildings.gid"
> psql:/Users/bacmac/nyc_buildings.sql:3: NOTICE: CREATE TABLE / PRIMARY KEY
> will create implicit index "nyc_buildings_pkey" for table "nyc_buildings"
> CREATE TABLE
> psql:/Users/bacmac/nyc_buildings.sql:4: ERROR: function
> addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) does
> not exist
> LINE 1: SELECT AddGeometryColumn('','nyc_buildings','the_geom',2908,...
> ^
> HINT: No function matches the given name and argument types. You might need
> to add explicit type casts.
> psql:/Users/bacmac/nyc_buildings.sql:5: ERROR: current transaction is
> aborted, commands ignored until end of transaction block
> psql:/Users/bacmac/nyc_buildings.sql:6: ERROR: current transaction is
> aborted … and so on.
>
> I wonder if I need to adjust $PATH so that the function AddGeometryColumn is
> found? Even when I change directory to /usr/local/pgsql-9.0/bin my Mac cannot
> find psql if I type that command on its own. I always have to use the full
> pathname /usr/local/pgsql-9.0/bin/psql. Strange, because typing 'ls' after
> changing the directory brings up the complete list of files including psql.
>
> Bruce Callander
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
