GitHub user hsyuan opened a pull request:
https://github.com/apache/incubator-hawq/pull/1001
HAWQ-1136. Disable .psqlrc in minirepro
.psqlrc can create unexpected output and changes in formatting that don't
play nice with parse_oids().
```
psql database --pset footer -Atq -h localhost -p 5432 -U gpadmin -f
/tmp/20161012232709/toolkit.sql
{"relids": "573615536", "funcids": ""}
Time: 2.973 ms
```
Generates an Exception:
```
Traceback (most recent call last):
File "/usr/local/greenplum-db/./bin/minirepro", line 386, in <module>
main()
File "/usr/local/greenplum-db/./bin/minirepro", line 320, in main
mr_query = parse_oids(cursor, json_str)
File "/usr/local/greenplum-db/./bin/minirepro", line 151, in parse_oids
result.relids = json.loads(json_oids)['relids']
File "/usr/local/greenplum-db/ext/python/lib/python2.6/json/__init__.py",
line 307, in loads
return _default_decoder.decode(s)
File "/usr/local/greenplum-db/ext/python/lib/python2.6/json/decoder.py",
line 322, in decode
raise ValueError(errmsg("Extra data", s, end, len(s)))
ValueError: Extra data: line 2 column 1 - line 3 column 1 (char 39 - 54)
```
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/hsyuan/incubator-hawq HAWQ-1136
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/1001.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1001
----
commit 4a9eb3f513fef7b1d483de46fb7462b2013864d7
Author: Haisheng Yuan <[email protected]>
Date: 2016-11-03T11:05:14Z
HAWQ-1136. Disable .psqlrc in minirepro
.psqlrc can create unexpected output and changes in formatting that don't
play nice with parse_oids().
```
psql database --pset footer -Atq -h localhost -p 5432 -U gpadmin -f
/tmp/20161012232709/toolkit.sql
{"relids": "573615536", "funcids": ""}
Time: 2.973 ms
```
Generates an Exception:
```
Traceback (most recent call last):
File "/usr/local/greenplum-db/./bin/minirepro", line 386, in <module>
main()
File "/usr/local/greenplum-db/./bin/minirepro", line 320, in main
mr_query = parse_oids(cursor, json_str)
File "/usr/local/greenplum-db/./bin/minirepro", line 151, in parse_oids
result.relids = json.loads(json_oids)['relids']
File "/usr/local/greenplum-db/ext/python/lib/python2.6/json/__init__.py",
line 307, in loads
return _default_decoder.decode(s)
File "/usr/local/greenplum-db/ext/python/lib/python2.6/json/decoder.py",
line 322, in decode
raise ValueError(errmsg("Extra data", s, end, len(s)))
ValueError: Extra data: line 2 column 1 - line 3 column 1 (char 39 - 54)
```
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
