Re: How to reply to an existing bug?

2018-05-28 Thread Magnus Hagander
On Mon, May 28, 2018, 02:00 Erwin Brandstetter wrote: > I found an existing bug report and have something to add to it. > > What's the best way to reply to it? Just using a browser, with no > newsreader installed. > > This one: > > https://www.postgresql.org/message-id/flat/20170925084522.1442.32

Re: case statement within insert

2018-05-28 Thread Peter J. Holzer
On 2018-05-25 17:04:25 +0800, tango ward wrote: > > > I want to insert data from mysql into a table in postgresql. I want to check > when the subjectcode contains PE or NSTP so I can assign True or False to > another column in destination DB. > > > # Source data: > >  # Source data: MySQL >   

pgdg-keyring (or apt-key) failure on fresh 9.6 install

2018-05-28 Thread Moreno Andreo
Hi folks, I'm trying to install Postgresql 9.6 on a test machine in Google Cloud Platform After a fresh install with Debian 9 (just after the instance has been created) I follow steps from here https://wiki.postgresql.org/wiki/Apt (instead of pg 10 I install pg 9.6) During the installation p

Re: ERROR: found multixact from before relminmxid

2018-05-28 Thread Andres Freund
Hi, I think I found the bug, and am about to post a fix for it belo https://postgr.es/m/20180525203736.crkbg36muzxrj...@alap3.anarazel.de. Greetings, Andres Freund

Re: pgdg-keyring (or apt-key) failure on fresh 9.6 install

2018-05-28 Thread Tim Cross
Moreno Andreo writes: > Hi folks, > I'm trying to install Postgresql 9.6 on a test machine in Google Cloud > Platform > After a fresh install with Debian 9 (just after the instance has been > created) I follow steps from here > > https://wiki.postgresql.org/wiki/Apt > > (instead of pg 10 I in

How to drop a value from an ENUM?

2018-05-28 Thread Torsten Förtsch
Hi, I am absolutely sure a certain value of one of my ENUM types is not used in the entire database. Now I am asked to drop that value. Unfortunately, there is no ALTER TYPE DROP VALUE. On my development box I tried delete from pg_enum where enumtypid='my_type_name'::regtype and enumlabel='m

binaries for 11 beta compiled with --with-llvm?

2018-05-28 Thread Thomas Kellerer
Are there any plans to provide a binary download for the Postgres 11 beta with JITting enabled? Currently I can't find any packages under https://www.postgresql.org/download/ or http://www.enterprisedb.com/products-services-training/pgbindownload The only one I found was from BigSQL https://w

Re: binaries for 11 beta compiled with --with-llvm?

2018-05-28 Thread Andres Freund
Hi, On 2018-05-29 07:54:52 +0200, Thomas Kellerer wrote: > But neither the Linux binaries nor the Windows binaries were compiled with > the --with-llvm option > (will JITting be possible with Windows at all?) Not in 11. Greetings, Andres Freund

Re: binaries for 11 beta compiled with --with-llvm?

2018-05-28 Thread Thomas Kellerer
Andres Freund schrieb am 29.05.2018 um 08:28: >> But neither the Linux binaries nor the Windows binaries were compiled with >> the --with-llvm option >> (will JITting be possible with Windows at all?) > > Not in 11. I assumed that ;) Not a real problem. But what about Linux binaries with JITt