Re: proposal: psql \setfileref - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal: psql \setfileref
Date
Msg-id CAFj8pRBM1hvUqORuhJVyWGjcVGq=64aN5_u6Qm76gSdPM3nz0g@mail.gmail.com
Whole thread Raw
In response to Re: proposal: psql \setfileref  (Gilles Darold <gilles.darold@dalibo.com>)
Responses Re: proposal: psql \setfileref  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers


2016-10-10 15:17 GMT+02:00 Gilles Darold <gilles.darold@dalibo.com>:
Le 10/10/2016 à 14:38, Daniel Verite a écrit :
>       Gilles Darold wrote:
>
>>    postgres=# \setfileref b /dev/random
>>    postgres=# insert into test (:b);
>>
>> Process need to be killed using SIGTERM.
> This can be fixed by setting sigint_interrupt_enabled to true
> before operating on the file. Then ctrl-C would be able to cancel
> the command.

If we do not prevent the user to be able to load special files that
would be useful yes.

I don't think so special files has some sense, just I had not time fix this issue. I will do it early - I hope.

Regards

Pavel

--
Gilles Darold
Consultant PostgreSQL
http://dalibo.com - http://dalibo.org


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: PL/Python adding support for multi-dimensional arrays
Next
From: Robert Haas
Date:
Subject: Re: pgbench vs. wait events