[GRASS-user] db.test

[Paul Shapley]

Hi Grass Users,

Trying to connect to an existing postgres/postgis database in 7.0.2RC1 but
getting older connection details reported which may be preventing a newer
connection. Here is the output from 'db.test' below. Note the 'VAR' file is
showing the newest details (not revealed in full for the list). References
in the 'search_path' to 'public' and 'schema sde' details are from
connections going back some three years and creating a new mapset does not
change this:-
---------------------------------------------------------------------------------

WARNING:  invalid value for parameter "search_path":
""$user", public, sde"
DETAIL:  schema "sde" does not exist

-------------------------------------------------------------------------------------

(Mon Oct 26 12:39:56
2015)
db.test
test=test1
Using DB driver: pg
WARNING:  invalid value for parameter "search_path":
""$user", public, sde"
DETAIL:  schema "sde" does not exist
EXECUTE: OK
WARNING:  invalid value for parameter "search_path":
""$user", public, sde"
DETAIL:  schema "sde" does not exist
EXECUTE: OK
WARNING:  invalid value for parameter "search_path":
""$user", public, sde"
DETAIL:  schema "sde" does not exist
EXECUTE: OK
DBMI-PostgreSQL driver error:
Unable to select:
SELECT * FROM grass_test1
ERROR:  relation "grass_test1" does not exist
LINE 1: SELECT * FROM grass_test1
                      ^
WARNING:  invalid value for parameter "search_path":
""$user", public, sde"
DETAIL:  schema "sde" does not exist
DBMI-PostgreSQL driver error:
Unable to select:
SELECT * FROM grass_test1
ERROR:  relation "grass_test1" does not exist
LINE 1: SELECT * FROM grass_test1
                      ^
ERROR: EXECUTE: ******** ERROR ********
0a1,2
> 1|123.456|abcd
> 2||xxx
ERROR: RESULT: ******** ERROR ********
DBMI-PostgreSQL driver error:
Unable to select:
SELECT c1 FROM grass_test1 WHERE d1 < 500 / 2 AND i1 <> 2
AND c1 LIKE '%bc%'
ERROR:  relation "grass_test1" does not exist
LINE 1: SELECT c1 FROM grass_test1 WHERE d1 < 500 / 2 AND i1
<> 2  A...
                       ^
WARNING:  invalid value for parameter "search_path":
""$user", public, sde"
DETAIL:  schema "sde" does not exist
DBMI-PostgreSQL driver error:
Unable to select:
SELECT c1 FROM grass_test1 WHERE d1 < 500 / 2 AND i1 <> 2
AND c1 LIKE '%bc%'
ERROR:  relation "grass_test1" does not exist
LINE 1: SELECT c1 FROM grass_test1 WHERE d1 < 500 / 2 AND i1
<> 2  A...
                       ^
ERROR: EXECUTE: ******** ERROR ********
0a1
> abcd
ERROR: RESULT: ******** ERROR ********
WARNING:  invalid value for parameter "search_path":
""$user", public, sde"
DETAIL:  schema "sde" does not exist
EXECUTE: OK
WARNING:  invalid value for parameter "search_path":
""$user", public, sde"
DETAIL:  schema "sde" does not exist
EXECUTE: OK
WARNING:  invalid value for parameter "search_path":
""$user", public, sde"
DETAIL:  schema "sde" does not exist
EXECUTE: OK
DBMI-PostgreSQL driver error:
Unable to select:
SELECT * FROM grass_test1
ERROR:  relation "grass_test1" does not exist
LINE 1: SELECT * FROM grass_test1
                      ^
WARNING:  invalid value for parameter "search_path":
""$user", public, sde"
DETAIL:  schema "sde" does not exist
DBMI-PostgreSQL driver error:
Unable to select:
SELECT * FROM grass_test1
ERROR:  relation "grass_test1" does not exist
LINE 1: SELECT * FROM grass_test1
                      ^
0a1,3
> 1|123.456|abcd|
> 2|18.6|xxx|987
> 3|0|_\'_|
ERROR: EXECUTE: ******** ERROR ********
ERROR: RESULT: ******** ERROR ********
CREATE TABLE grass_test1 (i1 INTEGER, d1 DOUBLE PRECISION, c1 VARCHAR(20))
INSERT INTO grass_test1 VALUES ( 1, 123.456, 'abcd' )
INSERT INTO grass_test1 VALUES ( 2, null, 'xxx' )
SELECT * FROM grass_test1
SELECT c1 FROM grass_test1 WHERE d1 < 500 / 2 AND i1 <> 2  AND c1 LIKE
'%bc%'
INSERT INTO grass_test1 VALUES ( 3, 0.0, '_\''_' )
ALTER TABLE grass_test1 ADD COLUMN i2 INTEGER
UPDATE grass_test1 SET d1 = 18.6, i2 = 987  WHERE i1 = 2
SELECT * FROM grass_test1
DROP TABLE grass_test1
WARNING:  invalid value for parameter "search_path":
""$user", public, sde"
DETAIL:  schema "sde" does not exist
EXECUTE: OK
(Mon Oct 26 12:39:58 2015) Command finished (2 sec)



----------------------------------------------------------------------------------



'VAR' File contents below

DB_DRIVER: pg
DB_DATABASE: host=?????.?????-??????????.???.??,dbname=???????
DB_SCHEMA: grass_gis
DB_GROUP: postgres



-------------------------------------------------------------------------------------------------------------


-- 
*Paul J. Shapley *MSc CGeog (GIS) FRGS
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20151026/7d877ccd/attachment.html>