the installation of pgadmin4 makes me weep in frustration

2019-01-13 Thread robert
Hi There first, thanks a lot for the great an beautiful software we get from PostgreSQL and all people around it. But I wonder how it comes, that installing pgadmin4 is so incredibly hard? And no documentation. I would like to install pgadmin4 to my ubuntu 18.1 laptop. Where do I find doku

Array_agg and dimensions in Array

2019-01-13 Thread Mike Martin
I have come across a problem which I cant seem to solve in a nice way Basically I have a (small) table of tags What I need to is combine two concatenated fields with a literal value as an array element. First thought was using array_agg with a pre-created array as select array_agg(ARRAY['-metadat

Re: Static PostgreSQL Binaries (Linux + Windows)

2019-01-13 Thread Zach van Rijn
On Sun, 2019-01-13 at 09:35 -0500, Tom Lane wrote: > Zach van Rijn writes: > > ... > > The workaround is simply to ignore these errors during build > > until I or someone else can get around to supplying patches > > (in the next week or so; I have other commitments). > > TBH, there's going to be z

Logical replication issue with row level trigger

2019-01-13 Thread Aleš Zelený
Hello, I've found an issue with logical replication causing 1) large memory allocation by wal sender process (RSS 60GB) 2) large amount of "xid" files in $PGDATA/pg_replslot/ directory - seems to be amount of rows handled by trigger + few more Having several millions of files in a single director

Re: Question about MemoryContextRegisterResetCallback

2019-01-13 Thread Michel Pelletier
On Sun, Jan 13, 2019 at 9:30 AM Tom Lane wrote: > I suppose what you're doing is returning a pointer to a GraphBLAS object > as a Datum (or part of a pass-by-ref Datum)? If so, that's not going > to work terribly well, because it ignores the problem that datatype- > independent code is going to

Re: Question about MemoryContextRegisterResetCallback

2019-01-13 Thread Tom Lane
Michel Pelletier writes: > This is no doubt the most complex bit of C wrapper I've done for postgres, > and I've run into a bit of a snag. GraphBLAS objects are opaque handles > that have their own new/free functions. After reading mmgr/README I have > registered a callback with CurrentMemoryCon

Question about MemoryContextRegisterResetCallback

2019-01-13 Thread Michel Pelletier
Hello, I'm working on an extension to wrap the GraphBLAS linear algebra package. GraphBLAS provides a very flexible API over adjacency matrices for solving graph problems. I've got Matrix and Vector types wrapped, build aggregators and extraction functions to pivot tables into matrices and back,

Re: Static PostgreSQL Binaries (Linux + Windows)

2019-01-13 Thread Tom Lane
Zach van Rijn writes: > Under the hood, the only major "technique" is wrapping the 'gcc' > command with flags such as '-static' to ensure that everything > is built correctly, and using reliable toolchains [1]. > There is one minor issue in that the postgres build scripts no > longer appear to sup

Re: Static PostgreSQL Binaries (Linux + Windows)

2019-01-13 Thread Pratik Parikh
Thanks, I'll check it out. On Sun, Jan 13, 2019, 9:13 AM Zach van Rijn On Sun, 2019-01-13 at 00:51 -0500, Pratik Parikh wrote: > > Than you. nice to hear from you . Would be able to share the > > build scripts with community? are they open source? > > Hi Pratik, > > > Yes; the build scripts were

Re: Static PostgreSQL Binaries (Linux + Windows)

2019-01-13 Thread Zach van Rijn
On Sun, 2019-01-13 at 00:51 -0500, Pratik Parikh wrote: > Than you. nice to hear from you .  Would be able to share the > build scripts with community? are they open source? Hi Pratik, Yes; the build scripts were linked at the bottom of my original mail message in this chain: https://git.zv.io/x

Re: Static PostgreSQL Binaries (Linux + Windows)

2019-01-13 Thread Brent Wood
Does this support extensions such as Postgis & Timescale? Brent Wood Programme leader: Environmental Information Delivery NIWA DDI: +64 (4) 3860529 [cid:image419b22.PNG@6e8846bb.46b21a94] Brent Wood Principal Technician - GIS and Spatial Data Management Programme Lead

Re: How to always run UPDATE FROM despite missing records in the source table?

2019-01-13 Thread Andrew Gierth
> "Alexander" == Alexander Farber writes: Alexander> even though I wonder what is the (VALUES Alexander> ('20.20.20.20'::inet)) v(ip) construct there, some temporary Alexander> table which is then LEGT JOINed to the geoip table? The SQL spec calls it a . The VALUES clause behaves like a S

Re: How to always run UPDATE FROM despite missing records in the source table?

2019-01-13 Thread Alexander Farber
Thank you Adrian - On Fri, Jan 11, 2019 at 4:55 PM Adrian Klaver wrote: > On 1/11/19 4:50 AM, Alexander Farber wrote: > > https://www.db-fiddle.com/f/22jfWnsvqD8hVeFPXsyLbV/0 > > Why not put a test for the block in the function and then use different > UPDATE's depending on the result? > I didn