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
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
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
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
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
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 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
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
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
Table definition:
workflow_db=> \d workflow_execution_test
Table "public.workflow_execution_test"
Column | Type | Collation |
Nullable | Default
--+--+---+---
> 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
"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';
>
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
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
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?
>
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
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 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
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 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 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).
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.
>
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:
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
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
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
"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
> 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
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
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
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
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.
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
33 matches
Mail list logo
