Re: The Amazon CloudFront distribution is configured to block access from your country.

Jan Wieck writes: > On 4/11/21 11:16 AM, Ron wrote: >> If my software requires zlib, and I link to https://zlib.net/ on my page, >> then >> your logic absolutely means that I'm responsible for supporting zlib. > > Let's clarify "support" in this context. If you link to zlib.net, you are not >

Re: The Amazon CloudFront distribution is configured to block access from your country.

On 4/11/21 11:16 AM, Ron wrote: If my software requires zlib, and I link to https://zlib.net/ on my page, then your logic absolutely means that I'm responsible for supporting zlib. Let's clarify "support" in this context. If you link to zlib.net, you are not responsible for zlib itself. But i

Re: How can I insert the image as a blob in the table

Hi, David, On Sun, Apr 11, 2021 at 6:57 PM David G. Johnston wrote: > > On Sunday, April 11, 2021, Igor Korot wrote: >> >> Hi, David, >> >> >> On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston >> wrote: >> >> > If you can decide on what client interface you want to use there should be >> > exi

Re: How can I insert the image as a blob in the table

On Sunday, April 11, 2021, David G. Johnston wrote: > On Sunday, April 11, 2021, Igor Korot wrote: > >> Hi, David, >> >> >> On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston >> wrote: >> >> > If you can decide on what client interface you want to use there should >> be existing resources on the

Re: How can I insert the image as a blob in the table

On Sunday, April 11, 2021, Igor Korot wrote: > Hi, David, > > > On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston > wrote: > > > If you can decide on what client interface you want to use there should > be existing resources on the web walking through how to do this using that > client interface

Re: How can I insert the image as a blob in the table

Hi, David, On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston wrote: > > On Sun, Apr 11, 2021 at 2:04 PM Igor Korot wrote: >> >> Hi, ALL, >> I have an image on my hard drive and I'd like to store it in the BLOB >> column of the images table. >> >> Is there a simple SQL to do that in PostgreSQL?

Re: Prepare Statement VS Literal Values

This looks like early vs late binding problem, also seen in  other products.  When you prepare the sql, the optimizer has no way of knowing the values which is going to be supplied in future.  So it is possible that at the time of preparing PG settles on a plan and uses it for all values, regardles

Re: How can I insert the image as a blob in the table

On Sun, Apr 11, 2021 at 2:04 PM Igor Korot wrote: > Hi, ALL, > I have an image on my hard drive and I'd like to store it in the BLOB > column of the images table. > > Is there a simple SQL to do that in PostgreSQL? > > SQL proper has no concept of "your hard drive". You need to define what you p

Prepare Statement VS Literal Values

Hi Team, I am struggling a lot on this for at least 3-4 queries. When I run explain analyze using literal values the query takes good plan but as soon as I use bind variable using the prepare statement it is going for toss and the same query is taking a lot of time. testdb=# select version();

RE: Re: Reuse of REF Cursor

I speculate that I am in the good old problem .. of a very slow plan of NOT IN (We used to convert it to NOT EXISTS in V8). Is this planner issue still in V9? Has the planner fixed for it in V10? Thanks Danny

How can I insert the image as a blob in the table

Hi, ALL, I have an image on my hard drive and I'd like to store it in the BLOB column of the images table. Is there a simple SQL to do that in PostgreSQL? Thank you.

Re: Reuse of REF Cursor

"Abraham, Danny" writes: > 2021-04-09 08:00:08.692 IDTERROR: canceling statement due to statement > timeout I don't know why you would think that a statement timeout is somehow the fault of the refcursor variable you used. You need to look at whether your timeout is a sane value, and if so, wh

RE: Re: Reuse of REF Cursor

2021-04-09 08:00:08.692 IDTERROR: canceling statement due to statement timeout 2021-04-09 08:00:08.692 IDTCONTEXT: PL/pgSQL function orhpans_active_clean_table(character varying,integer) line 42 at FETCH PL/pgSQL function orhpans_active_removal() line 31 at assignment PL/pgSQL fu

Re: Reuse of REF Cursor

"Abraham, Danny" writes: > stmt := 'select count(*) from ' || table_name; >open C1 for execute stmt; >fetch C1 into rc; >close C1; >... That still isn't a self-contained example; perhaps more usefully, you've not told us exactly what error you're seeing, either. FWIW, I tried

RE: Re: Reuse of REF Cursor

stmt := 'select count(*) from ' || table_name; open C1 for execute stmt; fetch C1 into rc; close C1; if (debug_level = 1) then if rc > 0 then perform diag_print(func_name,format('Counted %s records in table %s',rc,table_name) ); else perform diag_print

Re: The Amazon CloudFront distribution is configured to block access from your country.

On 4/11/21 8:11 AM, felix.quin...@yahoo.com wrote: The link https://www.postgresql.org/download/ in the PostgreSQL Downloads section, Windows, redirects to the page https://www.postgresql.org/download/windows/. There are only two links in it and both redirect to the EnterpriseDB site. At no ti

Re: The Amazon CloudFront distribution is configured to block access from your country.

On 4/11/21 8:16 AM, Ron wrote: That is ALL I said, and that is ALL I meant. DO NOT put words in my mouth! If my software requires zlib, and I link to https://zlib.net/ on my page, then your logic absolutely means that I'm responsible for supporting zlib. Except the route was: https://www

Re: The Amazon CloudFront distribution is configured to block access from your country.

On 4/11/21 2:53 AM, Stephan Knauss wrote: Hello Felix, On 11.04.2021 02:31, felix.quin...@yahoo.com wrote: I see no reason why ask elsewhere first, the link for the installer download is on the Postgresql website, not elsewhere. The most logical thing to do is ask here first. Because it is t

Re: Reuse of REF Cursor

"Abraham, Danny" writes: > Has anybody faced a problem with reusing a ref cursor? Your fragment looks like it ought to work, but it's hard to say where the problem is without seeing a complete example. > PG Version 9.5.5 on Linux. 9.5.x is EOL, and the last release in that series was 9.5.25, so

Re: The Amazon CloudFront distribution is configured to block access from your country.

On 4/11/21 10:07 AM, Israel Brewster wrote: On Apr 11, 2021, at 6:52 AM, Ron > wrote: On 4/11/21 9:12 AM, Israel Brewster wrote: On Apr 11, 2021, at 1:53 AM, Stephan Knauss > wrote: Hello Felix, On 11.04.2021 02:31, felix.quin..

Re: The Amazon CloudFront distribution is configured to block access from your country.

The link https://www.postgresql.org/download/ in the PostgreSQL Downloads section, Windows, redirects to the page https://www.postgresql.org/download/windows/. There are only two links in it and both redirect to the EnterpriseDB site. At no time is it clarified that it is a third party, even th

Re: The Amazon CloudFront distribution is configured to block access from your country.

On Sunday, April 11, 2021, Ron wrote: > > Your comment means that the owners of any web page which links to a third > party product must support that third-party product, just by virtue of > supporting it. That's crazy. > > We could do a better job on making it clear that the community project d

Re: The Amazon CloudFront distribution is configured to block access from your country.

> On Apr 11, 2021, at 6:52 AM, Ron wrote: > > On 4/11/21 9:12 AM, Israel Brewster wrote: >>> On Apr 11, 2021, at 1:53 AM, Stephan Knauss >> > wrote: >>> >>> Hello Felix, >>> >>> On 11.04.2021 02:31, felix.quin...@yahoo.com >>> w

Re: Reuse of REF Cursor

On Sunday, April 11, 2021, Abraham, Danny wrote: > > PG Version 9.5.5 on Linux. > > As neither your minor nor major version are supported you will find support to find limited if you get any at all. David J.

Re: Who altered the database?

On Fri, 9 Apr 2021 13:14:17 +0200 Durumdara wrote: > > What can we do to get info about the change (who did it, from what IP, when > it happened) in the future? > > As I see we can't define precisely what we want to log... All or nothing. > Create a web interface to apply the changes and have

Reuse of REF Cursor

Has anybody faced a problem with reusing a ref cursor? C1 refcursor; stmt := 'select1 ' ; open C1 for execute stmt; fetch C1 into rc1; close C1; stmt := 'select2 ...' ; open C1 for execute stmt; fetch C1 into rc2; close C1; ??? I am getting inconsistent errors:

Re: The Amazon CloudFront distribution is configured to block access from your country.

On 4/11/21 9:12 AM, Israel Brewster wrote: On Apr 11, 2021, at 1:53 AM, Stephan Knauss > wrote: Hello Felix, On 11.04.2021 02:31, felix.quin...@yahoo.com wrote: I see no reason why ask elsewhere first, the link for the installer

Re: The Amazon CloudFront distribution is configured to block access from your country.

> On Apr 11, 2021, at 1:53 AM, Stephan Knauss wrote: > > Hello Felix, > > On 11.04.2021 02:31, felix.quin...@yahoo.com wrote: >> I see no reason why ask elsewhere first, the link for the installer download >> is on the Postgresql website, not elsewhere. The most logical thing to do is >> ask h

Re: The Amazon CloudFront distribution is configured to block access from your country.

As my point of view better to connect VPN, it's a best option for you and you can download easily. On Sun, 11 Apr 2021, 3:23 pm Stephan Knauss, wrote: > Hello Felix, > > On 11.04.2021 02:31, felix.quin...@yahoo.com wrote: > > I see no reason why ask elsewhere first, the link for the installer >

Re: The Amazon CloudFront distribution is configured to block access from your country.

Hello Felix, On 11.04.2021 02:31, felix.quin...@yahoo.com wrote: I see no reason why ask elsewhere first, the link for the installer download is on the Postgresql website, not elsewhere. The most logical thing to do is ask here first. Because it is the Postgresql installer. https://www.ent