Hi Tom,
Thanks for the clarification.
Regards
Vikas
On Tue, 7 Dec 2021 at 14:45, Tom Lane wrote:
> Vikas Sharma writes:
> > Is it possible in postgres to get the value of the parameter currently
> set
> > in the session of the other user?
>
> No. That information only exists within the other
On 07.12.21 08:51, Avi Weinberg wrote:
Just to clarify, they are disabled during initial sync only or are always
disabled on subscriber side?
Are all triggers disabled during initial sync or just foreign keys?
All triggers are by default disabled on replicas. See the ALTER TABLE
clauses DISA
On 07.12.21 17:10, Zwettler Markus (OIZ) wrote:
I did a pgbouncer configuration using the following ini file:
[databases]
* = host=localhost port=5433 auth_user=pgbouncer
Using the name "pgbouncer" for auth_user is buggy. Try using a
different name.
On 2021-12-07 22:41:38 -0500, Tom Lane wrote:
> I think what you are looking for is NUMERIC. (The type name NUMBER
> is an Oracle-ism, I believe. I'm not sure how closely that corresponds
> to our NUMERIC.)
Not very. Oracle NUMBER is a decimal floating point number with a 38
digit mantissa store
We can do this:
select count(*) from regexp_matches('Great London', 'Great
London|Information Centre|Department for Transport', 'g');
Is it possible to allow null as an option? something like this
select count(*) from regexp_matches('Great London', 'null|Great
London|Information Centre|Department
Am Wed, Dec 08, 2021 at 12:07:13PM + schrieb Shaozhong SHI:
> We can do this:
> select count(*) from regexp_matches('Great London', 'Great
> London|Information Centre|Department for Transport', 'g');
>
> Is it possible to allow null as an option? something like this
> select count(*) from reg
Simply a bug.
https://github.com/pgbouncer/pgbouncer/issues/568
Cheers, Markus
> -Ursprüngliche Nachricht-
> Von: Zwettler Markus (OIZ)
> Gesendet: Dienstag, 7. Dezember 2021 17:10
> An: pgsql-general@lists.postgresql.org
> Betreff: error connecting to pgbouncer admin console
>
> I d
Hi, thanks for your answer!
Yeah, that's correct, I meant NUMERIC and not NUMBER. It was late and I must
have accidentally mixed up the names... But thanks for pointing that out! :)
But just to clarify, the data type NUMERIC is a fixed point number and not a
floating point number?
Alright, s
Hi, Karsten,
That sounds interesting.
Any good example?
Regards, David
On Wed, 8 Dec 2021 at 12:10, Karsten Hilbert
wrote:
> Am Wed, Dec 08, 2021 at 12:07:13PM + schrieb Shaozhong SHI:
>
> > We can do this:
> > select count(*) from regexp_matches('Great London', 'Great
> > London|Informa
On Wed, 8 Dec 2021 17:07:27 +
Shaozhong SHI wrote:
>
> Any good example?
>
Plenty of them in the fine documentation :
https://www.postgresql.org/search/?q=coalesce
-- Bien à vous, Vincent Veyron
https://compta.libremen.com
Logiciel libre de compta
On 12/8/2021 4:07 AM, Shaozhong SHI wrote:
> We can do this:
> select count(*) from regexp_matches('Great London', 'Great London|Information
> Centre|Department for Transport', 'g');
>
> Is it possible to allow null as an option? something like this
> select count(*) from regexp_matches('Great Lo
11.5 on linux
server = VM provided by our IT dept (IOW, can be grown if needed)
DB itself is on NFS
So far, the tables I have in my DB have relatively low numbers of records
(most are < 10K, all are < 10M). Things have been running great in terms
of performance. But a project is being brainstorm
On 2021-12-08 14:44:47 -0500, David Gauthier wrote:
> So far, the tables I have in my DB have relatively low numbers of records
> (most
> are < 10K, all are < 10M). Things have been running great in terms of
> performance. But a project is being brainstormed which may require some
> tables
> to
Спасибо!
--
С уважением, Дмитрий!
ср, 8 дек. 2021 г. в 22:58, Paul van der Linden :
> This one quite nicely explains it:
> https://stackoverflow.com/questions/14897816/how-can-i-prevent-postgres-from-inlining-a-subquery
>
> On Wed, Dec 8, 2021 at 3:14 AM David G. Johnston <
> david.g.johns...@gm
14 matches
Mail list logo
