PostGIS should not print entire files on errors

[knutole]

Some PostGIS errors will output the entire contents of a table. This messes up the logs real bad. Need to tune log report level to include errors, but not dumping tables, etc.

[strk]

I'm not away of any PostGIS or PostgreSQL error that would dump all of a table's data. Do you have a way to reproduce what you're seeing ?

[strk]

Maybe it's the CONTEXT of a big INSERT or COPY operation ?

[knutole]

Yes, it's on error when INSERT'ing. Let me know if that's enough, if not I'll try to reproduce.

[strk]

On ERROR, the statement generating the error is logged, like this:

strk=# INSERT INTO x values ('a','b','c');
ERROR:  relation "x" does not exist
LINE 1: INSERT INTO x values ('a','b','c');
                    ^

Verbosity can be tweaked as a session variable:

strk=# \set VERBOSITY terse
strk=# INSERT INTO x values ('a','b','c');
ERROR:  relation "x" does not exist at character 13