回复:回复:回复:回复:回复:A question about leakproof

2022-10-17 Thread qiumingcheng
OK, got it. Thank you very much. -- 发件人:Tom Lane 发送时间:2022年10月18日(星期二) 00:27 收件人:qiumingcheng 抄 送:Laurenz Albe ; Julien Rouhaud ; pgsql-general ; yuexingzhi 主 题:Re: 回复:回复:回复:回复:A question about leakproof "qiumingcheng" writes: >

Re: 回复:回复:回复:回复:A question about leakproof

2022-10-17 Thread Tom Lane
"qiumingcheng" writes: > Yes, It's capable of throwing an error(timestamp out of range) , but the > message "timestamp out of range" is not sensitive information. Really? Whether that's true at all is a matter of opinion. There's also the prospect that somebody could determine the value of a su

回复:回复:回复:回复:A question about leakproof

2022-10-17 Thread qiumingcheng
> It's capable of throwing an error (see timestamp2timestamptz_opt_overflow). Yes, It's capable of throwing an error(timestamp out of range) , but the message "timestamp out of range" is not sensitive information. Only from this function(timestamp_gt_timestamptz), can it be marked as leakproof? -

Re: could not find shared library for Python

2022-10-17 Thread Adrian Klaver
On 10/17/22 07:56, jacktby wrote: Please: 1) Do not top post. Do inline or bottom posting. 2) Do not use images, copy and paste text. 3) Answer from previous post: How did you upgrade from Python 2.7 to 3.7? and If you run python at the command line do you get the Python 3.7 in

Re: could not find shared library for Python

2022-10-17 Thread jacktby
jacktbyjack...@gmail.com Replied Message From Adrian Kla

Re: could not find shared library for Python

2022-10-17 Thread Adrian Klaver
On 10/17/22 07:07, jacktby wrote: I use CentOS7 and upgrade python2.7 to python3.7, but it gives me an How did you upgrade from Python 2.7 to 3.7? If you run python at the command line do you get the Python 3.7 interpreter? error "could not find shared library for Python",I use t

Re: could not find shared library for Python

2022-10-17 Thread Rob Sargent
> On Oct 17, 2022, at 8:07 AM, jacktby wrote: > > > > I use CentOS7 and upgrade python2.7 to python3.7, but it gives me an error > "could not find shared library for Python",I use the newest code from github > repo, how should I do? > > jacktby > jack...@gmail.com > >

Re: 回复:回复:回复:A question about leakproof

2022-10-17 Thread Laurenz Albe
On Mon, 2022-10-17 at 16:24 +0800, qiumingcheng wrote: > > "you seem to be imagining that changes in a query's plan on the basis of > > changes > > in collected statistics have something to do with this.  They do not." > > 1. My understanding of the above paragraph is that for the same view and >

Re: 回复:回复:回复:A question about leakproof

2022-10-17 Thread Tom Lane
"qiumingcheng" writes: > 2. What's the reason about the function timestamp_gt_timestampz may cause > data leakage? Can you explain how it causes data leakage? It's capable of throwing an error (see timestamp2timestamptz_opt_overflow). Now, maybe that's unreachable, or maybe we could rerrange th

could not find shared library for Python

2022-10-17 Thread jacktby
I use CentOS7 and upgrade python2.7 to python3.7, but it gives me an error "could not find shared library for Python",I use the newest code from github repo, how should I do?

Re: About foreign data wrapper

2022-10-17 Thread Ian Lawrence Barwick
2022年10月17日(月) 16:36 Rama Krishnan : > > Hi all, > > What Is the difference between dblink and foreign data wrapper? Basically, dblink enables you to execute individual queries on a remote PostgreSQL server via a function and use the results in a local query e.g.: SELECT * FROM dblink('my

Fedora 37

2022-10-17 Thread Kieran McCusker
Hi Is there any timeline for a Fedora 37 repository as it should be released tomorrow? Many thanks Kieran

回复:回复:回复:A question about leakproof

2022-10-17 Thread qiumingcheng
> "you seem to be imagining that changes in a query's plan on the basis of > changes > in collected statistics have something to do with this. They do not." 1. My understanding of the above paragraph is that for the same view and different users, the proleakproof=false attribute of the function w

About foreign data wrapper

2022-10-17 Thread Rama Krishnan
Hi all, What Is the difference between dblink and foreign data wrapper? Thanks Ramakrishnan

Re: 回复:回复:A question about leakproof

2022-10-17 Thread Laurenz Albe
On Mon, 2022-10-17 at 13:17 +0800, qiumingcheng wrote: > > you seem to be imagining that changes in a query's plan on the basis of > > changes > > in collected statistics have something to do with this.  They do not. > > Sorry, I may not fully understand what you mean. I mean that after my tests,