Hello Devrim,
The problem is fixed in most of the repositories I synchronise, but in one I
now have a new one. With the package:
postgresql13-odbc-13.00.-1PGDG.rhel7.x86_64.rpm
For the pgdg13 RHEL 7 repository:
[MIRROR] postgresql13-odbc-13.00.-1PGDG.rhel7.x86_64.rpm: Downloading
succ
On 2023-05-03 15:23, Devrim Gündüz wrote:
Hi again,
On Tue, 2023-05-02 at 12:38 -0700, Evan Rempel wrote:
At our site we use reposync to copy the postgresql repositories to a
local repository.
When doing this on April 28 (and since) I exprience the following
package checksum matching errors.
On Wed, May 3, 2023 at 2:00 PM Dirschel, Steve <
steve.dirsc...@thomsonreuters.com> wrote:
> Thanks for the reply Jeff. Yes- more of an academic question. Regarding
> this part:
>
>
>
>Index Cond: ((workflow_id = 1070) AND ((status)::text = ANY
> ('{NOT_STARTED,PAUSED,PENDING,RUNNING}'::tex
Erik Wienhold writes:
> On 03/05/2023 20:17 CEST Nagendra Mahesh (namahesh)
> wrote:
>> I have a Postgres 14.4 cluster (AWS Aurora) to which I connect from my
>> application using JDBC.
Aurora uses, I believe, some other storage engine entirely than
community Postgres has.
>> Only in this tiny
Hi again,
On Tue, 2023-05-02 at 12:38 -0700, Evan Rempel wrote:
> At our site we use reposync to copy the postgresql repositories to a
> local repository.
>
> When doing this on April 28 (and since) I exprience the following
> package checksum matching errors.
>
I can confirm that this is
> On 03/05/2023 20:17 CEST Nagendra Mahesh (namahesh)
> wrote:
>
> I have a Postgres 14.4 cluster (AWS Aurora) to which I connect from my
> application using JDBC.
>
> I use liquibase for schema management - not only tables, but also a bunch of
> SQL stored procedures and functions. Basically, th
"Dirschel, Steve" writes:
> There are 2,981,425 rows where workflow_id = 1070. Does that change your
> theory of using an “in-index filter” for that plan? When you say there was a
> bit of speculation on the “boundard condition” vs “in-index filter” is the
> speculation on if Postgres has 2 d
I have a Postgres 14.4 cluster (AWS Aurora) to which I connect from my
application using JDBC.
I use liquibase for schema management - not only tables, but also a bunch of
SQL stored procedures and functions. Basically, there is one liquibase
changeSet that runs last and executes a set of SQL f
Thanks for the reply Jeff. Yes- more of an academic question. Regarding this
part:
Index Cond: ((workflow_id = 1070) AND ((status)::text = ANY
('{NOT_STARTED,PAUSED,PENDING,RUNNING}'::text[])))
Filter: (deleted_millis <= 0)
Buffers: shared hit=24
For this usage, the =ANY is applied
Because both the actual times and the expected costs are so similar to each
other, I am assuming you are asking this as more of an academic question
than a practical one. If it is actually a practical matter, you should
find a better example to present to us.
On Wed, May 3, 2023 at 9:17 AM Dirsch
Hello Bruce,
Thanks for the update. Let's see what will come out.
Greetings
Michael
3. Mai 2023 18:57, "Bruce Momjian" schrieb:
> The packagers are researching this problem now.
>
> ---
>
> On Wed, May 3, 2023 at 07:
The packagers are researching this problem now.
---
On Wed, May 3, 2023 at 07:33:02AM +, Brainmue wrote:
> Hello Evan,
>
> we have exactly the same problem and don't feel comfortable with it at the
> moment either.
>
> On May 2, 2023, at 10:23 PM, Wen Yi wrote:
>
> Hi team,
> can I use same user's information login in multile machines when connect to
> the postgres?
In short, yes. A given user can log in from any number of machines, I believe
even simultaneously (though I haven’t tried that specifically).
On Wed, May 3, 2023 at 9:54 AM Sergey Cherevko
wrote:
> Ubuntu 18.04.6 LTS (GNU/Linux 4.15.0-167-generic x86_64)
>
> OpenSSL 1.1.1 11 Sep 2018
>
> Sometimes i see this in postgres logs
>
So, your system is working normally most of the time? Or is it working
normally all of the time, and you just
On Wed, 3 May 2023 at 12:11, Michael J. Baars <
mjbaars1977.pgsql.hack...@gmail.com> wrote:
> The shared common address space is controlled by the clone(2) CLONE_VM
> option. Indeed this results in an environment in which both the parent and
> the child can read / write each other's memory, but dy
On 2023-05-03 06:35:26 -0600, Michael Loftis wrote:
> That is not a thread. Linux man clone right at the start …
>
> “clone, __clone2, clone3 - create a child process”
>
> What you want is pthread_create (or similar)
clone is the system call which is used to create both processes and
threads (in
Hi Michael,
Are pthread_* functions really such an improvement over clone? Does it make
an 'freely passing around' of PGresult objects possible? Like it matters,
process or thread.
We were talking about the documentation and this 'freely passing around'
PGresult object. I just don't think it is a
On 5/3/23 07:34, J.A. wrote:
Ah - I think I'm starting to follow.
what i was _trying_ to do is this
get value from a column and stick it into a variable.
now select * from a _number_ of tables and return a -multi recordsets-
from this single query. I'm not sure if that is the same terminology
The convention on these lists is to inline or, at worse, bottom-post.
On Wed, May 3, 2023 at 7:34 AM J.A.
wrote:
> now select * from a _number_ of tables and return a -multi recordsets-
> from this single query. I'm not sure if that is the same terminology, in
> pgsql?
>
> So is this possible?
>
Ah - I think I'm starting to follow.
what i was _trying_ to do is this
get value from a column and stick it into a variable.
now select * from a _number_ of tables and return a -multi recordsets- from
this single query. I'm not sure if that is the same terminology, in pgsql?
So is this possible
Ubuntu 18.04.6 LTS (GNU/Linux 4.15.0-167-generic x86_64)
OpenSSL 1.1.1 11 Sep 2018
Sometimes i see this in postgres logs
Found some similar threads, but not sure
https://github.com/modoboa/modoboa/issues/1702
https://postgrespro.com/list/thread-id/2585389
How i can to debug this?
2023-02-22
"J.A." writes:
> I must admit, I did try doing something like you suggested Erik. I tried
> things like:
> DO $$
> DECLARE
> v_application_id uuid;
> BEGIN
> SELECT application_id INTO v_application_id FROM applications
> WHERE code = 'pg-test-cc';
>
> On 03/05/2023 14:51 CEST J.A. wrote:
>
> Oh wow folks! I totally misunderstood the docs then. (I also tried to Read The
> Manual before I posted here, too :blush:)
>
> I must admit, I did try doing something like you suggested Erik. I tried
> things like:
>
> DO $$
> DECLARE
> v_application_id
Table definition:
workflow_db=> \d workflow_execution_test
Table "public.workflow_execution_test"
Column | Type | Collation |
Nullable | Default
--+--+---+---
Hi,
On Tue, 2023-05-02 at 12:38 -0700, Evan Rempel wrote:
> At our site we use reposync to copy the postgresql repositories to a
> local repository.
>
> When doing this on April 28 (and since) I exprience the following
> package checksum matching errors.
Thanks for the report.
This defini
Oh wow folks! I totally misunderstood the docs then. (I also tried to Read
The Manual before I posted here, too :blush:)
I must admit, I did try doing something like you suggested Erik. I tried
things like:
DO $$
DECLARE
v_application_id uuid;
BEGIN
SELECT appl
> On 03/05/2023 14:25 CEST J.A. wrote:
>
> ms-sql person here migrating over to pgsql. One of the first thing's I noticed
> with pgsql (or more specifically, PL/pgSQL) is that it doesn't support
> "variables" in a query?
>
> for example, here's some T-SQL:
>
> DECLARE @fkId INTEGER
>
> SELECT @fkI
That is not a thread. Linux man clone right at the start …
“clone, __clone2, clone3 - create a child process”
What you want is pthread_create (or similar)
There’s a bunch of not well documented dragons if you’re trying to treat a
child process as a thread. Use POSIX Threads, as pretty much anyti
On Wed, May 03, 2023 at 10:25:55PM +1000, J.A. wrote:
> Heya folks :)
>
> ms-sql person here migrating over to pgsql. One of the first thing's I
> noticed with pgsql (or more specifically, PL/pgSQL) is that it doesn't
> support "variables" in a query?
>
> for example, here's some T-SQL:
>
> DECL
Heya folks :)
ms-sql person here migrating over to pgsql. One of the first thing's I
noticed with pgsql (or more specifically, PL/pgSQL) is that it doesn't
support "variables" in a query?
for example, here's some T-SQL:
DECLARE @fkId INTEGER
SELECT @fkId = fkId FROM SomeTable WHERE id = 1
-- a
Hi Peter,
The shared common address space is controlled by the clone(2) CLONE_VM
option. Indeed this results in an environment in which both the parent and
the child can read / write each other's memory, but dynamic memory being
allocated using malloc(3) from two different threads simulaneously wi
On 5/3/23 01:23, Wen Yi wrote:
Hi team,
can I use same user's information login in multile machines when connect
to the postgres?
Your question is a bit ambiguous, since:
1. "login in (to) multiple machines" typically refers logging in to the OS,
and that has nothing to do with postgresql, an
Hello Evan,
we have exactly the same problem and don't feel comfortable with it at the
moment either.
We even synchronise several versions and this problem occurs with all of them.
Can anyone confirm that the packages have not been changed inadvertently but
only the metadata is
wrong?
Here are t
33 matches
Mail list logo
