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

On 4/12/21 7:22 PM, Jan Wieck wrote: On 4/12/21 7:16 PM, Ron wrote: On 4/12/21 5:33 PM, Jan Wieck wrote: On 4/12/21 5:13 PM, felix.quin...@yahoo.com wrote: Unfortunately the official site for downloading the installer is blocked for me. I only had that option and trust what I am downloading.

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

> On Apr 12, 2021, at 8:31 PM, Abdul Qoyyuum wrote: > > Have you tried > > insert into table(picture) values(lo_import('D:\image.jpg')); > ? > No, I’m doing some non-standard compression on the way down.

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

Have you tried insert into table(picture) values(lo_import('D:\image.jpg')); ? On Tue, Apr 13, 2021 at 9:30 AM Igor Korot wrote: > Hi, guys, > > On Sun, Apr 11, 2021 at 7:08 PM Igor Korot wrote: > > > > Hi, David, > > > > On Sun, Apr 11, 2021 at 6:57 PM David G. Johnston > > wrote: > > > >

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

On 4/12/21 8:29 PM, Igor Korot wrote: Hi, guys, On Sun, Apr 11, 2021 at 7:08 PM Igor Korot wrote: 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 yo

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

> > On Apr 12, 2021, at 7:29 PM, Igor Korot wrote: > > Hi, guys, > > On Sun, Apr 11, 2021 at 7:08 PM Igor Korot > wrote: >> >> Hi, David, >> >> On Sun, Apr 11, 2021 at 6:57 PM David G. Johnston >> wrote: >>> >>> On Sunday, April 11, 2021, Igor Korot wrote:

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

Hi, guys, On Sun, Apr 11, 2021 at 7:08 PM Igor Korot wrote: > > 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: > >>

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

On 4/12/21 5:13 PM, felix.quin...@yahoo.com wrote: Unfortunately the official site for downloading the installer is blocked for me. I only had that option and trust what I am downloading. That wasn't your only option. Other members have suggested that you contact EnterpriseDB directly. Note

Re: Prepare Statement VS Literal Values

Thank you for the pointer, here is plan now, it is much better: testdb=# prepare fooplan(character varying,character varying ,bigint,character varying) AS select testdb-# this_.warehouse_cost_id , this_.asin , this_.base_currency_code, testdb-# this_.cost , this_.cost_acquisition_date , this_.cos

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

Unfortunately the official site for downloading the installer is blocked for me. I only had that option and trust what I am downloading. On Monday, April 12, 2021, 03:55:37 PM GMT-4, Condor wrote: On 12-04-2021 17:53, felix.quin...@yahoo.com wrote: > The entire enterprisedb site is blocked

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

On 12-04-2021 17:53, felix.quin...@yahoo.com wrote: The entire enterprisedb site is blocked for me. It's an American company, so I imagine it's happening. In the end I ended up downloading it from www.download3k.es. I checked the installer certificate and it seems to be correct. Thank you very m

Re: Reuse of REF Cursor

On 4/11/21 1:02 PM, Abraham, Danny wrote: 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_remova

Re: Ways to "serialize" result set for later use?

> Checking data (DML), if functions are doing the right things is something we do in our code unit tests. This is exactly what I am writing, unit tests for my code (which is pl/pgsql). This is an ELT pipeline for my customers to bulk update their data in my system, with detailed error reporting f

RE: Ways to "serialize" result set for later use?

From: Adam Brusselback Sent: Saturday, April 10, 2021 9:06 PM To: pgsql-general Subject: Ways to "serialize" result set for later use? Hey there everyone, I am going through the process of writing my first pgtap tests for my database, and I wanted to get some feedback on if my solution seems f

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

The entire enterprisedb site is blocked for me. It's an American company, so I imagine it's happening. In the end I ended up downloading it from www.download3k.es. I checked the installer certificate and it seems to be correct. Thank you very much to all On Sunday, April 11, 2021, 11:38:43 AM

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

On Mon, Apr 12, 2021 at 1:33 AM Magnus Hagander wrote: > > Yeah, this is definitely something we could work on improving. Would > just adding a sentence after the link saying "This download is > provided externally by EDB" (very much open to input on exactly what > the sentence should be)? Or wer

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

On Sun, Apr 11, 2021 at 5:25 PM Adrian Klaver wrote: > > 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 e