postgresql-http-client icon indicating copy to clipboard operation
postgresql-http-client copied to clipboard

exception URLError Missing left parenthesis

Open mtou091 opened this issue 7 years ago • 1 comments

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

mtou091 avatar Aug 10 '18 07:08 mtou091

@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=#

NikolayS avatar Aug 26 '18 20:08 NikolayS