[GRASS-user] v.external to layer in PostGIS database

[Nikos Alexandris]

Just to document here the way out:

1. First, and not posted here previously, there was a "problem" related to
the number of object locks allocated for each transaction:

```
db.tables -p
DBMI-PostgreSQL driver error:
Unable to select view names.
ERROR: out of shared memory
HINT: You might need to increase max_locks_per_transaction.
```
(see also
https://www.postgresql.org/docs/9.1/static/runtime-config-locks.html)

This was solved by the database admin by increasing the corresponding
parameter.


2. The test "test1" fails for the instruction
```
INSERT INTO grass_test1 VALUES ( 3, 0.0, '_\''_' )
```

Guess: related to the "backslash". Maybe the test "test1" needs to be
updated to account for how PostgreSQL treats "escape" string constants.
Have to yet test this.


3. Adding, finally, a primary key, whose name doesn't really matter
(whether it is 'cat' or 'id' or 'wdpaid'), allows GRASS GIS to read the
table in question.

This IS also among the notes of PostgreSQL driver
(https://grass.osgeo.org/grass74/manuals/grass-pg.html).

Nikos
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 228 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20180508/eaaaf270/attachment.sig>