On Thu, 2020-05-28 at 11:39 -0400, em...@encs.concordia.ca wrote:
> psql12.3 + jdbc_fdw(oracle18.x), tried:
[got bad query results]
How about giving oracle_fdw a try?
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
On Thu, May 28, 2020 at 5:14 PM Marc Munro wrote:
> On Wed, 2020-05-27 at 14:42 -0700, Michel Pelletier wrote:
> > Hi Marc,
> >
> > You can sign content with pgsodium:
> >
> > https://github.com/michelp/pgsodium
>
> Michel,
> Yay! A modern crypto implementation. And it seems to do most of what
On Wed, 2020-05-27 at 14:42 -0700, Michel Pelletier wrote:
> Hi Marc,
>
> You can sign content with pgsodium:
>
> https://github.com/michelp/pgsodium
Michel,
Yay! A modern crypto implementation. And it seems to do most of what
I need right out of the box with way less work than pgcrypto.
Any
Zwettler Markus (OIZ) writes:
> Hi Marco,
>
>
>
> How do you handle these conflicts? No longer updating that regularly or not
> at all anymore?
>
Not doing the updates is a poor option due to the potential security
vulnerabilities this may lead to. Likewise, delaying the application of
upda
Ying Lu writes:
> For Q1:
> QUERY PLAN
> ---
> Aggregate (cost=5.40..5.41 rows=1 width=8) (actual time=1267.001.
Hello,
Please find the info for both SQLs (removed yr)
For Q1:
QUERY PLAN
---
Aggregate (cost=5.40..5.41 rows=
On 5/28/20 9:59 AM, Ying Lu wrote:
Hello,
would help to see the EXPLAIN ANALYZE for the queries above.
And the EXPLAIN ANALYZE for the first query?
Also please include the entire query, for example:
EXPLAIN ANALYZE select count(*) from oracle_t1 as a inner join local_t1
as b on (a.c1 = b.c
On 5/28/20 8:39 AM, em...@encs.concordia.ca wrote:
Hello,
psql12.3 + jdbc_fdw(oracle18.x), tried:
[1]
select count(*)
from oracle_t1 as a
inner join local_t1 as b
on (a.c1 = b.c1);
return 100 records
[2]
select count(*)
from oracle_t1 as a
inner join local_t1 as b
on (a.c1 = b.c1
OR
Hello,
psql12.3 + jdbc_fdw(oracle18.x), tried:
[1]
select count(*)
from oracle_t1 as a
inner join local_t1 as b
on (a.c1 = b.c1);
return 100 records
[2]
select count(*)
from oracle_t1 as a
inner join local_t1 as b
on (a.c1 = b.c1
OR
a.c2 = b.c1
);
return only 2 records
(no null va
On Thu, May 28, 2020 at 02:36:34PM +, Zwettler Markus (OIZ) wrote:
> Hi Adrian,
>
> I'm not talking about this specific bug or its resolution.
>
> I want to talk about the Linux update problem in general.
>
> Anyone updating Linux might get such nerving dependency troubles.
>
> How do you hand
On 5/28/20 7:36 AM, Zwettler Markus (OIZ) wrote:
-Ursprüngliche Nachricht-
Von: Adrian Klaver
Gesendet: Donnerstag, 28. Mai 2020 16:15
An: Zwettler Markus (OIZ) ; PostgreSQL General
Betreff: Re: Linux Update Experience
On 5/28/20 12:59 AM, Zwettler Markus (OIZ) wrote:
We are running P
> -Ursprüngliche Nachricht-
> Von: Adrian Klaver
> Gesendet: Donnerstag, 28. Mai 2020 16:15
> An: Zwettler Markus (OIZ) ; PostgreSQL General
>
> Betreff: Re: Linux Update Experience
>
> On 5/28/20 12:59 AM, Zwettler Markus (OIZ) wrote:
> > We are running PGDG Postgres 9.6 and 12 on RHEL7
On 5/28/20 12:59 AM, Zwettler Markus (OIZ) wrote:
We are running PGDG Postgres 9.6 and 12 on RHEL7.
Our Linux team does global Linux updates on a quarterly basis (yum update).
We are hitting more and more update problems.
Some troubles this time:
+ Postgis24 has been updated to Postgis30
+ P
På torsdag 28. mai 2020 kl. 15:26:42, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>:
Andreas Joseph Krogh writes:
> Is there a way to define "sorting-rules" on custom-types so that I can have
> ORDER BY and PG will pick my custom
odering?
You'd have to write your own type, which would be a lo
Andreas Joseph Krogh writes:
> Is there a way to define "sorting-rules" on custom-types so that I can have
> ORDER BY and PG will pick my custom odering?
You'd have to write your own type, which would be a lotta work :-(.
A possible partial answer is to define the composite type as
f
På torsdag 28. mai 2020 kl. 14:50:54, skrev Geoff Winkless mailto:pgsqlad...@geoff.dj>>:
On Thu, 28 May 2020 at 13:14, Andreas Joseph Krogh wrote:
> This works:
> select p.firstname, p.lastname, p.firstname || p.lastname as fullname from
onp_crm_person p order by fullname;
>
> But this does
On Thu, 28 May 2020 at 13:14, Andreas Joseph Krogh wrote:
> This works:
> select p.firstname, p.lastname, p.firstname || p.lastname as fullname from
> onp_crm_person p order by fullname;
>
> But this doesn't:
> select p.firstname, p.lastname, p.firstname || p.lastname as fullname from
> onp_crm_
Dear Markus,
we are doing Updates almost continously/daily. The dependeny problems occur
since a few days/1-2 weeks (?).
The Updates are pending since then - hoping for package maintainers to fix
this, but did not yet address this in Bugtracker.
Marco
Von: Zwettler Markus (OIZ) [mailto:markus.
Hi.
This works:
select p.firstname, p.lastname, p.firstname || p.lastname as fullname from
onp_crm_person p order by fullname;
But this doesn't:
select p.firstname, p.lastname, p.firstname || p.lastname as fullname from
onp_crm_person p order by lower(fullname);
ERROR: column "fullname" doe
Hi Marco,
How do you handle these conflicts? No longer updating that regularly or not at
all anymore?
Thanks,
Markus
Von: Marco Lechner
Gesendet: Donnerstag, 28. Mai 2020 11:01
An: Zwettler Markus (OIZ) ; PostgreSQL General
Betreff: AW: Linux Update Experience
Hi Markus,
at the moment w
On Thu, 2020-05-28 at 09:00 +, Marco Lechner wrote:
> Hi Markus,
>
> at the moment we are facing similar conflicts on Oracle LInux 7 (wich
> is derived from RHEL) – we manage our machines using Spacewalk. The
> conflicts occur (as expected) on Spacewalk as well as on manually
> using yum:
>
Hi !
Le mer. 27 mai, vers 22:15, postgann2020 s exprimait :
>
> Thanks for your support.
>
> Environment Details:
> OS: RHEL 7.2
> Postgres: 9.5.15
> Master-Slave with Streaming replication
>
> We are planning to implement the monitoring tool for our environment.
>
> Could someone please sugge
Hi Markus,
at the moment we are facing similar conflicts on Oracle LInux 7 (wich is
derived from RHEL) - we manage our machines using Spacewalk. The conflicts
occur (as expected) on Spacewalk as well as on manually using yum:
Fehler: Paket: postgresql11-devel-11.8-1PGDG.rhel7.x86_64
(oraclelin
On 28.05.2020 9:59, Zwettler Markus (OIZ) wrote:
We are running PGDG Postgres 9.6 and 12 on RHEL7.
Our Linux team does global Linux updates on a quarterly basis (yum
update).
We are hitting more and more update problems.
Some troubles this time:
+ Postgis24 has been updated to Postgis30
+
We are running PGDG Postgres 9.6 and 12 on RHEL7.
Our Linux team does global Linux updates on a quarterly basis (yum update).
We are hitting more and more update problems.
Some troubles this time:
+ Postgis24 has been updated to Postgis30
+ Postgres 12.2 has been updated to Postgres 12.3 claimi
25 matches
Mail list logo
