Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

exception URLError Missing left parenthesis #1

Open
mtou091 opened this issue Aug 10, 2018 · 1 comment
Open

exception URLError Missing left parenthesis #1

mtou091 opened this issue Aug 10, 2018 · 1 comment

Comments

@mtou091
Copy link

mtou091 commented Aug 10, 2018

ERROR: malformed record literal: "Error in http_clien._get(): exception URLError occured." 详细:Missing left parenthesis. 在位置:while creating return value PL/Python function "_get"

@NikolayS
Copy link
Owner

@mtou091 thank you for this message.

Could you please provide exact instructions on how to repeat the error?
And what is your Postgres version?

I've checked the current code from master branch, and simple get(..) call works as expected:

NikolayS:postgresql-http-client nikolay$ psql -p6543
Timing is on.
Pager is always used.
psql (10.1, server 9.6.8)
Type "help" for help.

nikolay=# create database http;
CREATE DATABASE
Time: 1133.046 ms (00:01.133)
nikolay=# \c http
psql (10.1, server 9.6.8)
You are now connected to database "http" as user "nikolay".
http=# \i ./install.sql
CREATE EXTENSION
Time: 88.643 ms
CREATE SCHEMA
Time: 6.543 ms
DO
Time: 48.418 ms
CREATE TYPE
Time: 13.557 ms
CREATE FUNCTION
Time: 95.148 ms
CREATE FUNCTION
Time: 7.080 ms
CREATE FUNCTION
Time: 1.729 ms
http=#
http=#
http=#  select (get).* from http_client.get('http://ya.ru');
 url_requested |  url_received  | status_code |
---------------+----------------+-------------+------------------------------------------------------------------------------------------------
 http://ya.ru  | https://ya.ru/ |         200 | {"content-length": "12587", "x-content-type-options": "nosniff", "content-security-policy": "co
(1 row)
Time: 1988.690 ms (00:01.989)
http=#

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants