[GENERAL] Re: "missing chunk number XX for toast value YY in pg_toast ..." after pg_basebackup.

2016-03-06 Thread fredrik
HI All, i would really appreciate any help I can get on this issue. basically, a pg_basebackup + streaming attach, led to a database that we could not read from afterwards. Beset regards, Fredrik PS please advise if this is better posted on another list.

Re: [GENERAL] Does a call to a language handler provide a context/session, and somewhere to keep session data?

2016-03-06 Thread David G. Johnston
On Sun, Mar 6, 2016 at 10:21 PM, wrote: > Given that a language handler would be expected to be persistent, and to > support concurrent (and reentrant) calls within a single database, is there > a unique context or session identifier available? > > Is there a place to store data, to be retrieved

[GENERAL] Does a call to a language handler provide a context/session, and somewhere to keep session data?

2016-03-06 Thread david
Given that a language handler would be expected to be persistent, and to support concurrent (and reentrant) calls within a single database, is there a unique context or session identifier available? Is there a place to store data, to be retrieved later in the same session? Is there a place to s

Re: [GENERAL] Subtract one array from another, both with non-unique elements

2016-03-06 Thread Pavel Stehule
Hi 2016-03-06 18:41 GMT+01:00 Alexander Farber : > Thank you, but shouldn't I better use FOREACH for my task? > > SQL based solution (functional based) solution can be faster and shorter. PLpgSQL is nice language, but what you can do about arrays functionally, you should to do :). Usually it is s

Re: [GENERAL] Subtract one array from another, both with non-unique elements

2016-03-06 Thread Alexander Farber
Thank you, but shouldn't I better use FOREACH for my task? On Sun, Mar 6, 2016 at 6:34 PM, bricklen wrote: > On Sun, Mar 6, 2016 at 9:22 AM, Alexander Farber < > alexander.far...@gmail.com> wrote: > >> could someone please recommend the most efficient way subtracting >> elements of one array fro

Re: [GENERAL] Subtract one array from another, both with non-unique elements

2016-03-06 Thread bricklen
On Sun, Mar 6, 2016 at 9:22 AM, Alexander Farber wrote: > could someone please recommend the most efficient way subtracting elements > of one array from the other in PostgreSQL 9.5? > There are quite a few examples of array functions at http://postgres.cz/wiki/Array_based_functions, probably wor

[GENERAL] Subtract one array from another, both with non-unique elements

2016-03-06 Thread Alexander Farber
Hello, could someone please recommend the most efficient way subtracting elements of one array from the other in PostgreSQL 9.5? Should I create a new array or can I work on the existing one (and if the latter - will FOREACH work well when elements are removed "from under its feet"?). Both array

Re: [GENERAL] PostgreSQL 9.5 and process REST calls enquiry

2016-03-06 Thread Adrian Klaver
On 03/05/2016 05:34 PM, Stefan Keller wrote: I'd like to extend (and complete) this thread by collecting programs/frameworks/applications that provide REST services over Postgres. I see following categories and open source web frameworks and/or libs: Those which * attach Postgres directly, like