Hello,
Your point of view is interesting. May I discuss it ?
One answered to me on my question about " bug (ou not) in CTE Common Table
Expressions or Subqueries in the FROM Clause " :
" Its doesn’t have to seem logical to you, but this is how it is defined to
work and thus the observed behav
I have a client running a PostgreSQL 14 environment on windows. I have found
documentation on enabling LDAP auth for pgAdmin 4 and attempted to edit my
config.py file, but have not been successful. Does anyone have a walk-through
or any advice for enabling LDAP authentication for Postgres runn
Hi,
I have tried to read about Oracle's spatial partitioning feature (
https://www.oracle.com/technetwork/database/enterprise-edition/spatial-twp-partitioningbp-10gr2-05-134277.pdf)
and wondered if something like this is possible with PostgreSQL (with
PostGIS):
The first part, getting the rows in
Hi,
I am using dblink extension and getting connection name using
dblink_get_connections() function if it do not return specified name then
establishing a new connection and if it return then using same connection. But
there is one weird behaviour, if someone killed session then
dblink_get_con
PALAYRET Jacques writes:
> For me, one of the two following things should be true : either the hint (in
> case of a lateral error) is incomplete or the possibility of " cross join
> lateral " should be removed.
The reason the hint is worded the way it is is a practical one: the other
possibili
On Mon, Apr 11, 2022 at 7:20 AM Tom Lane wrote:
> PALAYRET Jacques writes:
> > For me, one of the two following things should be true : either the hint
> (in case of a lateral error) is incomplete or the possibility of " cross
> join lateral " should be removed.
>
> The reason the hint is wor
I'm using postgres 14 in a database recently brought over from postgres
10. (I did not do the bringing over.)
In my set-up, I partition datasets by schema, create a role per schema
and part of that is this explicit permission granting (from superuser):
p\g
grant all on all tables in sc
On 4/11/22 16:10, Rob Sargent wrote:
I'm using postgres 14 in a database recently brought over from postgres
10. (I did not do the bringing over.)
In my set-up, I partition datasets by schema, create a role per schema
and part of that is this explicit permission granting (from superuser):
Adrian Klaver writes:
> On 4/11/22 16:10, Rob Sargent wrote:
>> I've just bumped into this.
>>
>> barnard=> select public.genome_threshold_mono('a'::text,'b'::text);
>> ERROR: permission denied for schema public
>> LINE 1: select public.genome_threshold_mono('a'::text,'b'::text);
>>
>> I know I
On 4/11/22 17:34, Tom Lane wrote:
Adrian Klaver writes:
On 4/11/22 16:10, Rob Sargent wrote:
I've just bumped into this.
barnard=> select public.genome_threshold_mono('a'::text,'b'::text);
ERROR: permission denied for schema public
LINE 1: select public.genome_threshold_mono('a'::text,'b'::t
> On Apr 11, 2022, at 6:51 PM, Adrian Klaver wrote:
>
> On 4/11/22 17:34, Tom Lane wrote:
>> Adrian Klaver writes:
On 4/11/22 16:10, Rob Sargent wrote:
> I've just bumped into this.
>
> barnard=> select public.genome_threshold_mono('a'::text,'b'::text);
> ERROR: permiss
11 matches
Mail list logo
