On Fri, 2019-04-26 at 20:25 +, Jean-Philippe Chenel wrote:
> > > 1. So my question is, how can I compile this version of postgresql
> > > (9.6.9) and have the same real things
> > > of the default previously installed version, but with the
> > > --with-krb-srvnam=POSTGRES_DEV to change the
>
On 4/26/19 3:53 PM, Steven Schlansker wrote:
On Apr 26, 2019, at 2:33 PM, Rob Sargent wrote:
On 4/26/19 3:25 PM, Steven Schlansker wrote:
How can I efficiently implement the feature I've described? It seems difficult
to use computed indexing with GIN.
Storing the map in a child table
> On Apr 26, 2019, at 2:33 PM, Rob Sargent wrote:
>
>
> On 4/26/19 3:25 PM, Steven Schlansker wrote:
>>
>>
>> How can I efficiently implement the feature I've described? It seems
>> difficult to use computed indexing with GIN.
>>
> Storing the map in a child table (parentId, UUID, int) i
On 4/26/19 3:25 PM, Steven Schlansker wrote:
Hi Postgres fans,
We store a Java Map in Postgres as a jsonb column.
As json does not have a UUID type, it is of course stored as text.
A simple value might be:
{"04e623c0-6940-542f-a0de-4c999c626dfe": 5000,
"6d3e24b6-9e8c-5eb1-9e4c-f32cc40864
On Fri, Apr 26, 2019 at 2:25 PM Steven Schlansker <
stevenschlans...@gmail.com> wrote:
> How can I efficiently implement the feature I've described? It seems
> difficult to use computed indexing with GIN.
>
Don't use a computed index? Add a trigger to populate a physical column
and index that.
Hi Postgres fans,
We store a Java Map in Postgres as a jsonb column.
As json does not have a UUID type, it is of course stored as text.
A simple value might be:
{"04e623c0-6940-542f-a0de-4c999c626dfe": 5000,
"6d3e24b6-9e8c-5eb1-9e4c-f32cc40864c9": 20825}
I am trying to implement an effi
On 26/04/2019 18:19, Tom Lane wrote:
> =?utf-8?Q?J=C4=81nis_P=C5=ABris?= writes:
>> This is only reproducible with SSL connection.
>
> Seems like you might get more insight from OpenSSL experts, then.
> (No idea where you find some, but they must exist.)
List-Id:
--
Cheers,
Jeremy
=?utf-8?Q?J=C4=81nis_P=C5=ABris?= writes:
> This is only reproducible with SSL connection.
Seems like you might get more insight from OpenSSL experts, then.
(No idea where you find some, but they must exist.)
regards, tom lane
Thanks for the insight, Tom.
> It's fairly obvious from the postmaster log that the client side
> is not bothering to close the transaction it started
Thats what I was also thinking, but I've managed to reproduce it with
autocommit or commit before closing connection as well.
This is only reprod
=?utf-8?Q?J=C4=81nis_P=C5=ABris?= writes:
> I'm trying to do a simple health check for keepalived and other services via
> a python script and psycopg2 library. All seems to be all right, until I
> close the connection, at which point a packet with TCP reset is produced.
Hm. It's fairly obviou
Piotr Findeisen writes:
> Do you have any plans to support arrays with different number of dimensions
> in the type system?
Mmm ... don't hold your breath. People have speculated about that,
but I haven't seen any actual proposals, and it's hard to see how
we could do it without creating compati
On Fri, 2019-04-26 at 13:18 +, Jean-Philippe Chenel wrote:
> 1. So my question is, how can I compile this version of postgresql (9.6.9)
> and have the same real things
> of the default previously installed version, but with the
> --with-krb-srvnam=POSTGRES_DEV to change the
> default user nam
Hi,
Currently, when I make select version(), this version is installed.
PostgreSQL 9.6.9 on x86_64-pc-linux-gnu (Ubuntu 9.6.9-2.pgdg16.04+1), compiled
by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.9) 5.4.0 20160609, 64-bit
The database is running on the installation of Ubuntu 16.04 x64
I've configure
Hi Tom,
> On 16 Apr 2019, at 00:58, Tom Lane wrote:
>
> Joe Wildish writes:
>> We are seeing an inexplicable behaviour when issuing an "UPDATE..RETURNING"
>> statement. I am unsure if it is a Postgres bug. Additional eyes-on would be
>> much appreicated.
>
>> When issuing the following state
On 4/26/19 6:50 AM, Piotr Findeisen wrote:
> Presto type system however distinguishes array(integer),
> array(array(integer))...
> (using Presto therms). And execution is (expectedly) not as flexible.
Fine point here -- Postgres does not actually have arrays-of-arrays, it
has multi-dimension array
Hi Tom,
I think I understand now.
Postgres type system does not distinguish between array types with different
number of dimensions. int[], int[][] and int[][][][][][] are all equivalent
to the type system.
Number of dimensions is part of the value though and execution takes care
of it.
If I sub
On 26.04.19 09:41, Jānis Pūris wrote:
> /Resending the original message without any formatting./
>
> Hello,
>
> I'm trying to do a simple health check for keepalived and other
> services via a python script and psycopg2 library. All seems to be all
> right, until I close the connection, at which po
Resending the original message without any formatting.
Hello,
I'm trying to do a simple health check for keepalived and other services via a
python script and psycopg2 library. All seems to be all right, until I close
the connection, at which point a packet with TCP reset is produced.
This has
Hello,
I'm trying to do a simple health check for keepalived and other services via a
python script and psycopg2 library. All seems to be all right, until I close
the connection, at which point a packet with TCP reset is produced.
This has become very problematic and creates extensive noise in m
Hi Tom,
Thanks for your response.
I think I need to provide some context for my question.
I am maintaining Presto connector to Postgres (
https://github.com/prestosql/presto/tree/master/presto-postgresql).
When accessing a table in Postgres, we need to map columns' types to
appropriate types in
20 matches
Mail list logo
